Calculating the epoch time from standard time using awk and calculating the duration
Hi All,
I have the following time stamp data in 2 columns
.
.
etc
From this data I need the following output.
I tried to convert the second column into seconds using HH*60*60+MM*60+SS+MS(milliseconds) formula and subtracting line by line but the problem is if the date changes at some row, I don't know how to proceed.
May be converting ecah column into epoch time and adding together and subtracting row wise can work,
but i don't know how to do that.
Any help in this regard is highly helpful for me.
Thanks
Sidda
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 having the following problem.
test > hourOfDay=06 ; delayTime=$(((9-$hourOfDay)*60)) ; echo $delayTime
180
test > hourOfDay=07 ; delayTime=$(((9-$hourOfDay)*60)) ; echo $delayTime
120
test > hourOfDay=08 ; delayTime=$(((9-$hourOfDay)*60)) ; echo $delayTime
bash: (9-08: value... (5 Replies)
The date construct in UNIX can be used to calculate when something is finished: date -v+1H displays the time 1 hour from now.
I want to use the same construct in a script, but it is leading to error messages:
echo "Finished at: " `date -v+$durationH`
where $duration is calculated based on input... (3 Replies)
Dear Folks,
I want to calculate the elapsed hours between two time columns. I am using timestampdiff method for the same. I am able to get the value. But facing an issue of decimal values. For example the elapsed hours between 09:00:00 and 20:30:00 is coming as 11 instead of 11.5. I am using below... (1 Reply)
A report needs to come some what similar to this
No of elements Stream Batch No Load time
A B C D
A,B,C im able to get quite easily
wc -l /usr/local/intranet/areas/prod/output/SRGW_0?/*/MESSAGE_T.dat
O/P of above command.
A B C ... (1 Reply)
Hi,
I have a file containing 100,000 rows-by-120 columns and I need to compute for the standard deviation for each row. Any idea on how to calculate row-wise standard deviation using awk? My sample data looks like this:
input data:
23 35 12 25 16 17 18 19 29 12
12 26 15 14 15 23 12 12... (2 Replies)
Hey all. I am working on some scripts in bash to perform a variety of functions; there are a variety of steps involved, and they must happen in a specific sequence; what I need help with is a way to calculate some differences in a timestamp in a logfile.
One of the steps in the scripts I am... (3 Replies)
Hi All,
I have written script and wanted to know the run time of it in seconds. i used below logic but am not getting the results in second instead getting error.
cat pkloader.sh
# if you want to calculate the time in milliseconds then use $(date +%s%N)
START_TIME=`date +%s`
echo... (2 Replies)
Hi All,
I want to run a utility for all the process id that are running for more than 15 mins.
I have captured process id's and the time that they were run in a file like below
1st column represnts the process ids and the 2nd one is the Time
<
21014 01:00
21099 01:00
24361 01:03
24406... (5 Replies)
16:45:51 10051 77845
16:45:51 10051 77845
16:46:52 10051 77846
16:46:53 10051 77846
Match the last PID then subtract second line time with first line.
Please help me with any command or script.
working in media company on a project OS: RHEl7
tried command:
awk 'function... (2 Replies)
Discussion started by: vivekn
2 Replies
LEARN ABOUT DEBIAN
timetrans
TIMETRANS(1p) User Contributed Perl Documentation TIMETRANS(1p)NAME
timetrans - Converts time into time
SYNOPSIS
timetrans [units-options] [-count]
DESCRIPTION
timetrans converts time from one type of unit to another. If any of the units options are specified, then timetrans will convert those
time units into the number of seconds to which they add up. If given the count option, timetrans will convert that number of seconds into
the appropriate number of weeks, days, hours, minutes, and seconds. The converted result is printed out. Units options cannot be
specified in the same execution as the count option, and vice versa.
timetrans is intended for use with DNSSEC-Tools, for calculating a zone's expiration time.
OPTIONS
Units Options
The converted value of each unit is totaled and a single result printed.
-seconds seconds
Count of seconds to convert to seconds.
-minutes minutes
Count of minutes to convert to seconds.
-hours hours
Count of hours to convert to seconds.
-days days
Count of days to convert to seconds.
-weeks weeks
Count of weeks to convert to seconds.
Count Option
The specified seconds count is converted to the appropriate number of weeks, days, hours, minutes, and seconds.
-count seconds
Count of seconds to convert to the appropriate set of units.
Other Options
timetrans has the following miscellaneous options.
-Version
Displays the version information for timetrans and the DNSSEC-Tools package.
EXAMPLES
Example 1: Converting 5 days into seconds
$(42)> timetrans -days 5
432000
Example 2: Converting 2 weeks into seconds
$(43)> timetrans -w 2
1209600
Example 3: Converting 8 days and 8 hours into seconds
$(44)> timetrans -d 8 -hours 8
720000
Example 4: Converting 1 week, 1 day, and 8 hours into seconds
$(46)> timetrans -w 1 -days 1 -h 8
720000
Example 5: Converting 14 weeks, 4 days, 21 hours, 8 minutes, and 8 seconds into seconds
$(47)> timetrans -w 14 -d 4 -h 21 -m 8 -s 8
8888888
Example 6: Converting 720000 seconds into time units
$(48)> timetrans -c 720000
1 week, 1 day, 8 hours
Example 7: Converting 1814421 seconds into time units
$(49)> timetrans -c 1814421
3 weeks, 21 seconds
Example 8: Converting 8888888 seconds into time units
$(50)> timetrans -c 8888888
14 weeks, 4 days, 21 hours, 8 minutes, 8 seconds
COPYRIGHT
Copyright 2004-2012 SPARTA, Inc. All rights reserved. See the COPYING file included with the DNSSEC-Tools package for details.
AUTHOR
Wayne Morrison, tewok@tislabs.com
SEE ALSO zonesigner(8)Net::DNS::SEC::Tools::timetrans.pm(3)perl v5.14.2 2012-06-21 TIMETRANS(1p)