Sponsored Content
Top Forums Shell Programming and Scripting Convert Date from File and Calculate Duration Post 302637259 by Newbie2012 on Tuesday 8th of May 2012 03:04:30 PM
Old 05-08-2012
Convert Date from File and Calculate Duration

Hi - I am looking for a little help to read in 2 date fields from a file in format:

20120508134012.3
yyyymmddhhmmss.tenths of a second

So i want to:
1. Read in the 1st date from the file
2. Read in the second date from the file
3. Calculate the difference in minutes (or seconds)
4. Append the line of the original file with the "duration".

I am guessing the best approach would be to convert the date/times to epoch time, and subract. I have been searching the threads, but have not come up with anything. Any thoughts?

Thanks!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

calculate the date of next satureday of current date.

I want to calculate the date of next satureday of current date using shell script. Suppose, today is 27-feb-08 I want to get the date of next satureday, which means 01-mar-08, in the formate '' YYMMDD ". I do this in ksh.. Please tell me any type of command which help me out. Thanks in... (3 Replies)
Discussion started by: rinku
3 Replies

2. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

3. Shell Programming and Scripting

date duration fail to calculate

Hi Everyone, I was very sad after a long way but still cannot figure out the duration between two date. $date1="20090812 23:48:56"; $date2="20090813 00:01:37"; The output will be "001241". I did the following tries, like print localtime(UnixDate(ParseDate("20090812 23:48:56"),"%s"));... (2 Replies)
Discussion started by: jimmy_y
2 Replies

4. Shell Programming and Scripting

convert date inside a file

Hi guys I've got a file with this line inside. 200,2010,318,1000,4.377,70.9,.835,.592,.243,-.438,0,881 The line always begins with number 100 or number 200, follow the year, the day in the year, the hour, and other stuff Here, the important fields are, 2, 3 and 4. -Filed 2 --> year... (4 Replies)
Discussion started by: iga3725
4 Replies

5. Shell Programming and Scripting

Convert duration of the process to seconds

Hi, I am looking to write a script to kill the process which are running for more than 7 days. So i have a command like "ps -eo pid,etime,args | grep -i xxxx" ( process which has xxx in it and running for more than 7 days needs to be killed ). When i exeucte the above command , i am... (2 Replies)
Discussion started by: forums123456
2 Replies

6. Shell Programming and Scripting

Getting the Start, End time and duration using date command

Oracle Enterprise Linux We want to track how long a process takes to complete its execution. This is what we want in the schell script Before the process is started , get the time with date, hours and minutes execute the process After the process has ended , get the time with date,... (5 Replies)
Discussion started by: omega3
5 Replies

7. UNIX for Dummies Questions & Answers

Script shell calculate mean arrival request duration

hello, I have implemented this command : tshark -eth0 -T fiels -e frame.time et sip.Request-Line -z sip,stat > test2.txt the result of this command : test.txt: Aug 27, 2013 23:06:47.334270000 INVITE Aug 27, 2013 23:06:47.335045000 SIP/2.0 401 Unauthorized Aug 27, 2013... (1 Reply)
Discussion started by: Amouna
1 Replies

8. Shell Programming and Scripting

Compare fraction number and convert duration to seconds

Hi friends, I have a file with contents below: 01.m4a 00:14:45.82, 01.mp4 00:03:46.05, -659.770000 05.m4a 00:27:43.51, 05.mp4 00:27:45.10, 1.590000 06.m4a 00:11:39.73, 06.mp4 00:11:44.60, 4.870000 If 5th column value more than 3 or less than -3 then I should get its name (from first... (2 Replies)
Discussion started by: magnus29
2 Replies

9. UNIX for Beginners Questions & Answers

How to calculate time duration in Linux?

I want to calculate duration for below file in this format SID | Date | Starttime |Date |End time 1607 |2019-04-05|13:06:42|2019-04-05|13:07:12 2327 |2019-04-05|13:57:26|2019-04-05|13:57:43 O/p should be like this: SID | Date | Starttime |Date |Endtime... (4 Replies)
Discussion started by: anupmishra
4 Replies

10. Linux

How to calculate the quarter end date according to the current date in shell script?

Hi, My question is how to calculate the quarter end date according to the current date in shell script? (2 Replies)
Discussion started by: Divya_1234
2 Replies
Mojo::Date(3pm) 					User Contributed Perl Documentation					   Mojo::Date(3pm)

NAME
Mojo::Date - HTTP 1.1 date container SYNOPSIS
use Mojo::Date; my $date = Mojo::Date->new(784111777); my $http_date = $date->to_string; $date->parse('Sun, 06 Nov 1994 08:49:37 GMT'); my $epoch = $date->epoch; DESCRIPTION
Mojo::Date implements HTTP 1.1 date and time functions according to RFC 2616. Sun, 06 Nov 1994 08:49:37 GMT ; RFC 822, updated by RFC 1123 Sunday, 06-Nov-94 08:49:37 GMT ; RFC 850, obsoleted by RFC 1036 Sun Nov 6 08:49:37 1994 ; ANSI C's asctime() format ATTRIBUTES
Mojo::Date implements the following attributes. "epoch" my $epoch = $date->epoch; $date = $date->epoch(784111777); Epoch seconds. METHODS
Mojo::Date inherits all methods from Mojo::Base and implements the following new ones. "new" my $date = Mojo::Date->new; my $date = Mojo::Date->new($string); Construct a new Mojo::Date object. "parse" $date = $date->parse('Sun Nov 6 08:49:37 1994'); Parse date in one of the following formats. - Epoch format(784111777) - RFC 822/1123 (Sun, 06 Nov 1994 08:49:37 GMT) - RFC 850/1036 (Sunday, 06-Nov-94 08:49:37 GMT) - ANSI C asctime() (Sun Nov 6 08:49:37 1994) "to_string" my $string = $date->to_string; Render date suitable for HTTP 1.1 messages. SEE ALSO
Mojolicious, Mojolicious::Guides, <http://mojolicio.us>. perl v5.14.2 2012-09-05 Mojo::Date(3pm)
All times are GMT -4. The time now is 03:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy