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)
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)
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)
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)
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)
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)
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)
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)