Sponsored Content
Top Forums Shell Programming and Scripting Generate last hour date in YYYYmmddHH Post 302504545 by alvin0618 on Monday 14th of March 2011 10:42:47 PM
Old 03-14-2011
Generate last hour date in YYYYmmddHH

can some one show me how to generate last hour of date for example:
2012010100 -> 2011123123 // check first date of a new year
2008030100 -> 2008022923 // check leap year as well
And also no perl code is restricted.
This is what i am facing issue now, can someone provides help to me.

Last edited by alvin0618; 03-14-2011 at 11:49 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

generate rows from date.

Hi I have file like below has many rows with different dates and ids. ID FIRST_DT SEC_DT 111 2005-10-02 2010-10-01 222 2007-11-01 2040-09-13 I need to generate rows first_dt increment + 1 year until the SEC_DT year matches ,ID and sec_dt stays same ,here... (14 Replies)
Discussion started by: GrepMe
14 Replies

2. Shell Programming and Scripting

Get date and time for past 1 hour from current date

Hi, I need to get the date and time for past 1 hour from the current date. Anyone know how to do so? Thanks (5 Replies)
Discussion started by: spch2o
5 Replies

3. Shell Programming and Scripting

Unix Script for getting date and validating just Hour

Hi, Can someone guide me to write a unix script for getting a hour out of a date command and validating hour to see if its > 7 and < 16. if hours is >7 and <16 then assign a variable value of 0730 and if hour is >16 then assign a variable value of 1630? Help appreciated. Thanks in advance.... (9 Replies)
Discussion started by: zulfikarmd
9 Replies

4. Shell Programming and Scripting

Compare file timestamp with current date. Diff must be 1 hour.

Hello, I've created the script below to compare the content of two files with a delay of an hour. After an hour, the lines that exist in both files, will be printed and executed. The script now uses a counter to countdown 50 minutes. But what I would prefer is to check the file timestamp of... (3 Replies)
Discussion started by: taipan
3 Replies

5. Shell Programming and Scripting

Help to generate date from day of the year

Hi I want to convert the day of the year(yyyyddd) to date in mmddyy format Example: input is 2005029 --------> 29th day of 2005 I have to get the output as 01292005 ---> jan 29th 2005 I've to do this in K-Shell There were threads that dealt with coverting date to day of the year but I... (3 Replies)
Discussion started by: sudhamayeev
3 Replies

6. Shell Programming and Scripting

Generate quarter dates with begin date and end date

Hi All, I am trying to generate quarter dates with user giving input as begin date and end date. Example: Input by user: begin_date = "2009-01-01" end_date = 2010-04-30" required output: 2009-01-01 2009-03-31 09Q01 2009-04-01 2009-06-30 09Q02 . . till 2010-01-01 2010-03-31 10Q01 ... (9 Replies)
Discussion started by: sol_nov
9 Replies

7. Shell Programming and Scripting

Finding/Grep on files with date and hour in the file name

Hi, I have a folder structure as follows, DATA -> 2012-01-01 -> 00 -> ABC_2012-01-03_00.txt -> 01 -> ABC_2012-01-03_01.txt -> 02 -> ABC_2012-01-03_02.txt ... -> 23 -> ABC_2012-01-03_02.txt -> 2012-01-02 -> 2012-01-03 So the dir DATA contains the above hierarchy, User input Start and... (6 Replies)
Discussion started by: mihirvora16
6 Replies

8. UNIX for Advanced & Expert Users

Finding/Grep on files with date and hour in the file name

Hi, I have a folder structure as follows, DATA -> 2012-01-01 -> 00 -> ABC_2012-01-03_00.txt -> 01 -> ABC_2012-01-03_01.txt -> 02 -> ABC_2012-01-03_02.txt ... -> 23 -> ABC_2012-01-03_02.txt -> 2012-01-02 ... (1 Reply)
Discussion started by: mihirvora16
1 Replies

9. Solaris

Solaris 9 Zone : Date command in crontab shows delayed(One Hour) output

SOLARIS 9 Zone : date command in crontab shows delayed(One Hour) output Hi folks, the date command shows the correct date and time, How ever, if the date command executed through crontab in any form of scrip the output shows as one hour delayed, similar to date -u.. Can some one help in... (12 Replies)
Discussion started by: judi
12 Replies

10. Shell Programming and Scripting

Day/Hour diff between two date

Dear All I need to find out day diff between two dates. date -d or date -- day is not working in mine system. Currently i am using below code but it gives me wrong value while month change. IP: Date 1: 20150802 11:30:45 Date 2: 20150728 16:30:45 code used: awk '{t1=$2; t2=$4;... (7 Replies)
Discussion started by: jaydeep_sadaria
7 Replies
STRFTIME(3)						   BSD Library Functions Manual 					       STRFTIME(3)

NAME
strftime, strftime_z -- format date and time LIBRARY
Standard C Library (libc, -lc) SYNOPSIS
#include <time.h> size_t strftime(char * restrict buf, size_t maxsize, const char * restrict format, const struct tm * restrict timeptr); size_t strftime_z(const timezone_t tz, char * restrict buf, size_t maxsize, const char * restrict format, const struct tm * restrict timeptr); DESCRIPTION
The strftime() function formats the information from timeptr into the buffer buf according to the string pointed to by format. The format string consists of zero or more conversion specifications and ordinary characters. All ordinary characters are copied directly into the buffer. A conversion specification consists of a percent sign '%' and one other character. No more than maxsize characters will be placed into the array. If the total number of resulting characters, including the terminating null character, is not more than maxsize, strftime() returns the number of characters in the array, not counting the terminating null. Otherwise, zero is returned and the contents of the array are undefined. Each conversion specification is replaced by the characters as follows which are then copied into the buffer. %A is replaced by the locale's full weekday name. %a is replaced by the locale's abbreviated weekday name. %B is replaced by the locale's full month name. %b or %h is replaced by the locale's abbreviated month name. %C is replaced by the century (a year divided by 100 and truncated to an integer) as a decimal number [00,99]. %c is replaced by the locale's appropriate date and time representation. %D is replaced by the date in the format ``%m/%d/%y''. %d is replaced by the day of the month as a decimal number [01,31]. %e is replaced by the day of month as a decimal number [1,31]; single digits are preceded by a blank. %F is replaced by the date in the format ``%Y-%m-%d'' (the ISO 8601 date format). %G is replaced by the ISO 8601 year with century as a decimal number. %g is replaced by the ISO 8601 year without century as a decimal number (00-99). This is the year that includes the greater part of the week. (Monday as the first day of a week). See also the '%V' conversion specification. %H is replaced by the hour (24-hour clock) as a decimal number [00,23]. %I is replaced by the hour (12-hour clock) as a decimal number [01,12]. %j is replaced by the day of the year as a decimal number [001,366]. %k is replaced by the hour (24-hour clock) as a decimal number [0,23]; single digits are preceded by a blank. %l is replaced by the hour (12-hour clock) as a decimal number [1,12]; single digits are preceded by a blank. %M is replaced by the minute as a decimal number [00,59]. %m is replaced by the month as a decimal number [01,12]. %n is replaced by a newline. %p is replaced by the locale's equivalent of either ``AM'' or ``PM''. %R is replaced by the time in the format ``%H:%M''. %r is replaced by the locale's representation of 12-hour clock time using AM/PM notation. %S is replaced by the second as a decimal number [00,61]. The range of seconds is (00-61) instead of (00-59) to allow for the periodic occurrence of leap seconds and double leap seconds. %s is replaced by the number of seconds since the Epoch, UTC (see mktime(3)). %T is replaced by the time in the format ``%H:%M:%S''. %t is replaced by a tab. %U is replaced by the week number of the year (Sunday as the first day of the week) as a decimal number [00,53]. %u is replaced by the weekday (Monday as the first day of the week) as a decimal number [1,7]. %V is replaced by the week number of the year (Monday as the first day of the week) as a decimal number [01,53]. According to ISO 8601 the week containing January 1 is week 1 if it has four or more days in the new year, otherwise it is week 53 of the previous year, and the next week is week 1. The year is given by the '%G' conversion specification. %v is replaced by the date in the format ``%e-%b-%Y''. %W is replaced by the week number of the year (Monday as the first day of the week) as a decimal number [00,53]. %w is replaced by the weekday (Sunday as the first day of the week) as a decimal number [0,6]. %X is replaced by the locale's appropriate time representation. %x is replaced by the locale's appropriate date representation. %Y is replaced by the year with century as a decimal number. %y is replaced by the year without century as a decimal number [00,99]. %Z is replaced by the time zone name. %z is replaced by the offset from ITC in the ISO 8601 format ``[-]hhmm''. %% is replaced by '%'. The strftime_z() function is similar to strftime(), but it also takes a const timezone_t tz argument. SEE ALSO
date(1), printf(1), ctime(3), printf(3), strptime(3), tm(3) STANDARDS
The strftime() function conforms to ISO/IEC 9899:1999 (``ISO C99''). The '%C', '%D', '%e', '%g', '%G', '%h', '%k', '%l', '%n', '%r', '%R', '%s', '%t', '%T', '%u', '%V', and '%v' conversion specifications are extensions. Use of the ISO 8601 conversions may produce non-intuitive results. Week 01 of a year is per definition the first week which has the Thursday in this year, which is equivalent to the week which contains the fourth day of January. In other words, the first week of a new year is the week which has the majority of its days in the new year. Week 01 might also contain days from the previous year and the week before week 01 of a year is the last week (52 or 53) of the previous year even if it contains days from the new year. A week starts with Monday (day 1) and ends with Sunday (day 7). For example, the first week of the year 1997 lasts from 1996-12-30 to 1997-01-05. BUGS
There is no conversion specification for the phase of the moon. A return value of zero does not necessarily indicate an error. If the resulting string is an empty string, the result value is zero and it is not possible to distinguish between success and error. For example, in many locales %p yields an empty string. This problem can be avoided by inserting an extra space at the beginning of the format string and then skipping over it or removing it from the result. BSD
April 14, 2011 BSD
All times are GMT -4. The time now is 05:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy