I was having a look on threads on the Forum about time calculation but didn't find exactly this issue.
For instance, if we have these 2 dates, begin & end :
Code:
20100430235830
20100501000200
Is there anyway, awk, ksh, perl to calculate the difference in sec and get for our example : 210
Noting that the script should work for all dates and time of the year ...
It means leap years, months with 30 or 31 days, ... because begin & end dates could be more then several dates.
I'm working on a :
SunOS 5.10 Generic_118833-36 sun4u sparc SUNW,Sun-Fire-V240
Note that I had to adjust the time going in with a decimal point before seconds. Depending on how/where this number is coming from, you might need to do something with strings.
file1 & file2 can be deleted when done; other filenames can be used.
I executed your perl shell but got the following errors. Do you have an idea why ??
Code:
$ cat temp.sh
perl -MTime::Local -le'
/(....)(..)(..)(..)(..)(..)/g and
push @dt, timelocal $6, $5, $4, $3, $2 - 1, $1 - 1900
for @ARGV;
print $dt[1] - $dt[0] if eof;
' 20100430235830 20100501000200
$ perl temp.sh
Number found where operator expected at temp.sh line 7, near "' 20100430235830"
(Might be a runaway multi-line '' string starting on line 2)
(Missing operator before 20100430235830?)
Number found where operator expected at temp.sh line 7, near "20100430235830 20100501000200"
(Missing operator before 20100501000200?)
syntax error at temp.sh line 2, near "-le"
Execution of temp.sh aborted due to compilation errors.
Regs,
---------- Post updated at 10:11 AM ---------- Previous update was at 10:06 AM ----------
Oh, Sorry , I got it ....
I'm typing perl twice ... I don't know well this language yet ....
Hello,
In HP-UX how to find the date time difference ?
Start time: 28-APR-2019 21:36:01
End time : 29-APR-2019 00:36:04
----------------------
Difference is
----------------------
Much appreciate any pointer or view on this.
... (3 Replies)
Hi Everyone,
We are having an issue with date and date -u in our AIX Systems.
We have checked environment variable TZ and /etc/environment and however, we could not rectify the difference.
>date
Thu Mar 19 22:31:40 IST 2015
>date -u
Thu Mar 19 17:01:44 GMT 2015
Any clue... (5 Replies)
There are 2 dates,
Tue Oct 1 13:40:19 2013
Sun Sept 30 10:26:23 2013
I have multiple dates like the above one. How do I calculate the date time difference and display in another column in Shell script. Please help. (3 Replies)
Request ID GMDCOMTM GMDRRSTIME GMDRESTIME
<36812986> : : :I want to display the date -time difference in other fields. Above I have given for only 1 record. I want to calculate for all the records.
(GMCOMTM - GMDRRSTM) ,(GMDRRSTM-GMDRESTM) and... (5 Replies)
================================================================================
Request ID GMDCOM TIME GMDRRS TIME COM-RRS
================================================================================
<36812974> Tue Oct 1 13:32:40 2013 Tue Oct 1 20:36:42 2013... (1 Reply)
Hi,
I am trying to use the script as under :
echo "Please input the string (APC) in the format (APC=x-yyy-z):"
read a
for i in m1 m2 m4 m5 m6
do
cat /m12/$i/12* | grep -B 1 -A 1 inaccessible | gawk '/'$a'/{print $6,$7,$8,x};{x=$3" "$4}' | awk NF > temp
cat /m122/$i/12* | grep -B 1 -A 1... (0 Replies)
I have start and finish date in the following format -
Start Date: 5/21/2010 9:14:00 AM
End Date : 5/24/2010 7:23:00 AM
I need to get the time difference in the following format :mm or . Any help would be really appreciated.
Thank you! (3 Replies)
Hi,
Below is the backup file name (includes date & time) :
exp_trx_tables_18_Oct_2010_10_59_00.dmp
Extracted date and time from the file name as below using the below "awk"command:
date 18-Oct-2010 and time 10:59:00
echo "$fname" | awk -F"_" '{printf "Records will be restored as on... (1 Reply)
Hi guys,
I know that this topic has been discuss numerous times, and I have search the net and this forum for it.
However, non able to address the problem I faced so far.
I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Hi,
I am starting a process at 9 pm today and want to exit the process by 5am, the next day. Every day at 9pm the shell script will be invoked by autosys.
But how can i monitor in my script for 5 am and stop the process ?
there may be a case where the script can start at 4.59 am and... (4 Replies)