Hi All,
I know there has been a lot of things that have been written about date arithmetic, but perhaps I have missed something..
The following script takes the input from a file name fail.txt with the following format:
Where $1 is a file name and $2 is the creation timestamp.
I have attempted to calculate the age of the file from reading the timestamp($2)
heres the script i wrote
I get the error ":more tokens expected at the row where 'days_old" is being calculated(which is a minor issue).
The issue that i am more concerened with is
the "days_old" variable calculation is failing if the file is from the previous month or year.
I work on Solaris 8 so a lot of date options or the GNU date are not available to me.
I am only looking for a way to convert the timestamp of the fail.txt($2) to no of days from today.
I apologize if this has been discussed earlier but I was not able to find any age related threads.
In the following code snippet you are trying to subtract one datestring from another
e.g. 20080721 - 20060328. This is not how you calculate date differences. Have a look in the FAQs on this site for "Date Arithmetic" for further information on how to actually calculate the difference between two dates.
Hi fpmurphy,
The statement today=`TZ=aaa date +%Y%m%d` is derived from a staement that i took from this forum which helped me to calculate the date two days ago.
the aaa is a typo..Thanks for pointing out......
I have already looked up the Date Arethmetic sectiobut will lokk closer this time and get back..Thanks for your response.
Thanks
I need to convert the timestamp "20060328122808" in epoch time.
Then get the current epoch time of the system using
then subtract both the numbers to get the difference in epoch.
Then I should be able to convert the epoch time difference no of days..
does this sound possible.
All i need to know is how to convert the "20060328122808" to epoch time
and the how the convert the resultant epoch timestamp in no of days....
does this sound possible..??
Hi Friends,
I have 2 varaibles which contain
START=`date '+ %m/%d/%y %H:%M:%S'`
END=`date '+ %m/%d/%y %H:%M:%S'`
i want the time difference between the two variables in Seconds.
Plz help. (2 Replies)
Hi All
I want the time difference from current date time
For eg. From current date time i want to subtract 10 hrs and after subtracting i want the resultant in date time in MySql (1 Reply)
Is this way of finding the time difference a correct way of doing it or is it error-prone.
#****Check if lastrun exist. If exists check if the difference is 1 hour or not and act accordingly***********************
if ; then
lastrun_time=`cat $LOG_DIR/lastrun`
curr_time=`date +%s`
... (4 Replies)
Need some help please.
I am running SCO Openserver 5.07 on a Windows 2003 Server with VMware Server 1
If I run
# ps -ef|grep /etc/cron
the date that it shows the cron process started is older than the date I get from running the uptime command.
In other words it looks like the date... (2 Replies)
Hello All,
I have a problem calculating the time difference between start and end timings...!
the timings are given by 24hr format..
Start Date : 08/05/10 12:55
End Date : 08/09/10 06:50
above values are in mm/dd/yy hh:mm format.
Now the thing is, 7th(08/07/10) and... (16 Replies)
Hi,
I have a tab delimited file with GMT time. How to convert the GMT to PST time and store the line only if date falls to 2 days ago date.
Say today is 16, date should be of 14. or else remove the line
abc - -
efg - -
hij - -
kln - - ... (10 Replies)
Hi Experts...
I want to calculate the time difference between two date-time values (using ksh). It can return the difference in hours (or whatever..)
For eg: time_diff "09/12/2009 12:30" "09/10/2009 12:30" should return 1464 hours...
$time_diff "09/12/2009 12:30:00" "09/10/2009... (5 Replies)
Hi,
Please help me in calculating the time difference between below mentioned timestamps.
a=07/17/2007 02:20:00 AM MST
b=07/17/2007 02:07:46 AM MST
Thanks (2 Replies)
Hi,
i have one hard coded time which will be 23:45 and one will be sysdate (same date) and time less than 23:45.
i want to start my job at 23:45 and the input file will be arriving before that. so i want to make sure that the task starts only at 23:45 and from the input file time till 23:45... (3 Replies)
Hi All..
Does anyone have a useful function where I can enter two date/timestamps and it calculates the difference in time in hours, minutes and seconds between the 2?
Any feedback much appreciated. :D
Kind Regards
Satnam (1 Reply)