Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert Date from File and Calculate Duration
Top Forums Shell Programming and Scripting Convert Date from File and Calculate Duration Post 302637399 by fpmurphy on Tuesday 8th of May 2012 09:04:44 PM
Old 05-08-2012
If you are using the ksh93 shell:
Code:
exec 5<filename
read T1 <&5
read T2 <&5
exec 5<&-

E1=$( printf "%(%s)T" "${T1:0:8} ${T1:8:2}:${T1:10:2}:${T1:12:2}.${T1:14}" )
E2=$( printf "%(%s)T" "${T2:0:8} ${T2:8:2}:${T2:10:2}:${T2:12:2}.${T2:14}" )

echo "E2-E1 = $((E2-E1))"

These 2 Users Gave Thanks to fpmurphy For This Post:
Corona688 Newbie2012
 

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

LEARN ABOUT DEBIAN

mhc

mhc(5)								File Formats Manual							    mhc(5)

NAME

       mhc - Message Harmonized Calendaring system

DESCRIPTION

       This  manual  page  documents  briefly the mhc file format.  This manual page was written for the Debian GNU/Linux distribution because the
       original program does not have a manual page.

FIELDS

       Mhc file format is based on STD11/RFC822: Standard for the format of ARPA Internet text messages.  In mhc file, the following extra  header
       fields are used.

       X-SC-Day:
	      Date of event in format yyyymmdd.  You can specify multiple date with space separated like:

		 X-SC-Day: 19990409 19990413

	      which means April 9th 1999 and April 13th 1999.

       X-SC-Time:
	      Time of event in format hh:mm-hh:mm or hh:mm.  For event which has no meanings about time, you can leave it empty in this field.

       X-SC-Duration:
	      Period  of event in yyyymmdd-yyyymmdd.  You can omit start date or end date, like "19991121-".  X-SC-Duration: is used only to limit
	      date specified by X-SC-Day: or X-SC-Cond, so you can't describe event date only by X-SC-Duration:.  If X-SC-Duration: is	empty,	it
	      means no limit.

       X-SC-Cond:
	      Condition of event date by using following keyword.

		 00-31 Day of month.

		 1st 2nd 3rd 4th 5th Last Week in month.

		 Sun Mon ... Sat Day of week.

		 Jan Feb ... Dec Month

	      Examples,

		 X-SC-Cond: Tue Fri
			Every Tuesday and Friday.

		 X-SC-Cond: 31 Aug
			Every August 31th.

		 X-SC-Cond: 1st 3rd Fri
			Every 1st and 3rd Friday.

		 X-SC-Cond: Fri
		 X-SC-Day: !19990409
			Every Friday, but except April 9th 1999.

		 X-SC-Cond: Fri 13
			Every 13th and Every Friday, not 13th Friday.

       X-SC-Alarm:
	      Hint  for alarm of event.  Currently, mhc.el doesn't alaram, but gemcal will pop-up alarm window.  It will be useful if you transfer
	      this event to PalmOS.  In X-SC-Alarm:, you can specify the number (1 to 99) with suffix such as minute, hour or day.  For example,

		 X-SC-Alarm: 10 minutes
			Alarm 10 minutes before event.

		 X-SC-Alarm: 3 hour
			Alarm 3 hours before event.

		 X-SC-Alarm: 3 day
			Alarm 3 day before event.

       X-SC-Subject:
	      Subject of event. unstructured?

       X-SC-Location:
	      Location of event. unstructured?

       X-SC-Category
	      Category of event.  Any keyword, space separeated.  Case ignored.

       X-SC-Recoard-Id:
	      Internal use only.

SEE ALSO

       adb2mhc(1) gemcal(1), mhc-sync(1), mhc2palm(1), palm2mhc(1), today(1).

AUTHOR

       This program was written by Yoshinari Nomura <nom@quickhack.net> and this manual page was written by  Fumitoshi	UKAI  <ukai@debian.or.jp>,
       for the Debian GNU/Linux system (but may be used by others).

								    23 Jun 2000 							    mhc(5)
All times are GMT -4. The time now is 03:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy