Need help in finding in date difference


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help in finding in date difference
# 1  
Old 07-15-2012
Need help in finding in date difference

Hi,

My date is coming as
Code:
STARTDATE=Sun Jul 15 00:34:23 2012
ENDDATE=Sun Jul 15 00:50:04 2012

I want difference between these two dates,anyone's helps will be appriciated.

Thanks
Prasoon

Last edited by methyl; 07-15-2012 at 07:08 PM.. Reason: please use code tags
# 2  
Old 07-15-2012
With GNU tools:

Code:
STARTDATE="Sun Jul 15 00:34:23 2012"
ENDDATE="Sun Jul 15 00:50:04 2012"

rsd=$( date -d "$STARTDATE" +%s )  # raw start date
red=$( date -d "$ENDDATE" +%s )   # raw end date

echo "difference: $(( red - rsd )) seconds"

Convert each date to seconds since the epoch and subtract.

If you don't have GNU date, it would help to know what system you are using.
This User Gave Thanks to agama For This Post:
# 3  
Old 07-15-2012
@prasson_ibm
Just re-read the history of your posts and not managed to deduce what precise Operating System (an unknown vintage of IBM AIX?), or what Shell you use, or whether you have a modern version of Perl installed.

You posted a question nearly a year ago about date arithmetic which petered out because there was insufficient base information for anybody to post a solution to match your evolving requirement (only last post mentions the expected output format).

In the custom of this forum, please post the base information about your computer software, some representative sample input data which contains the date data, an explanation of the process, and the expected matching sample output data. Please mention the volume of data which needs to be processed and quote real numbers (i.e. not words like "huge").

Please do find out whether you have the BSD variant of the date command installed, and whether you have Perl installed (what version?), and whether you have ksh93 installed (unlikely with AIX but not impossible).

Last edited by methyl; 07-15-2012 at 07:10 PM.. Reason: grammar
# 4  
Old 07-16-2012
Quote:
Originally Posted by methyl
@prasson_ibm
Just re-read the history of your posts and not managed to deduce what precise Operating System (an unknown vintage of IBM AIX?), or what Shell you use, or whether you have a modern version of Perl installed.

You posted a question nearly a year ago about date arithmetic which petered out because there was insufficient base information for anybody to post a solution to match your evolving requirement (only last post mentions the expected output format).

In the custom of this forum, please post the base information about your computer software, some representative sample input data which contains the date data, an explanation of the process, and the expected matching sample output data. Please mention the volume of data which needs to be processed and quote real numbers (i.e. not words like "huge").

Please do find out whether you have the BSD variant of the date command installed, and whether you have Perl installed (what version?), and whether you have ksh93 installed (unlikely with AIX but not impossible).
Hi,

I am working on windows env where MKSToolkit is installed.

Last edited by prasson_ibm; 07-16-2012 at 01:24 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding difference between two columns of unequal length

Hi, I have two files which look like this cat waitstate.txt 18.2 82.1 cat gostate.txt 5.6 5.8 6.1 6.3 6.6 6.9 7.2 7.5 (4 Replies)
Discussion started by: jamie_123
4 Replies

2. Shell Programming and Scripting

Finding difference in between two array's of strings

Hi, Can anybody help me in finding the difference between two array elements with the help of code pls. purge=("Purge Concurrent Request and/or Manager Data" "Purge Signon Audit data" "Purge Obsolete Workflow Runtime Data" "Purge Logs and Closed System Alerts") purge_1=("Purge Obsolete... (3 Replies)
Discussion started by: Y.balakrishna
3 Replies

3. Shell Programming and Scripting

Finding difference in 2 different timestamps

Legends, I have a requirement to run the script exactly after one hour of completion of dependent script. Eg: Script B should run after one hour on the completion of Script A. I got the time stamps using following variables. these scripts runs in autosys > DATE=`date +%H:%M` >... (4 Replies)
Discussion started by: sdosanjh
4 Replies

4. Shell Programming and Scripting

Finding first difference between two files

Hi! I'd like to know if it is possible for a command to find the first difference between two large files, output that line from both file and stop, so no need to continue after that to save some computation time. I don't think looping through it will be efficient enough but that's the only... (6 Replies)
Discussion started by: Mojing
6 Replies

5. Shell Programming and Scripting

Converting a date to friday date and finding Min/Max date

Dear all, I have 2 questions. I have a file with many rows which has date of the format YYYYMMDD. 1. I need to change the date to that weeks friday date(Ex: 20120716(monday) to 20120720). Satuday/Sunday has to be changed to next week friday date too. 2. After converting the date to... (10 Replies)
Discussion started by: 2001.arun
10 Replies

6. Shell Programming and Scripting

finding date numeral from file and check the validity of date format

hi there I have file names in different format as below triss_20111117_fxcb.csv triss_fxcb_20111117.csv xpnl_hypo_reu_miplvdone_11172011.csv xpnl_hypo_reu_miplvdone_11-17-2011.csv xpnl_hypo_reu_miplvdone_20111117.csv xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies

7. Shell Programming and Scripting

finding difference between two files

Hi, I have two files one with 12486 lines second one with 13116 As per the comparsion between two files the count have 630 difference I used diff command to find the difference between two files but it's not understandable could any one suggest any command to get 630 records in a new... (4 Replies)
Discussion started by: thelakbe
4 Replies

8. Shell Programming and Scripting

finding the previous day date and creating a file with date

Hi guys, I had a scenario... 1. I had to get the previous days date in yyyymmdd format 2. i had to create a file with Date inthe format yyyymmdd.txt format both are different thanks guys in advance.. (4 Replies)
Discussion started by: apple2685
4 Replies

9. Shell Programming and Scripting

finding difference between 2 directory recursively

Hi, i'm trying to compare two directories in Unix. I need a recursive search ie my shell script should also compare common files in those two directory and so on... any clues.. ?? (2 Replies)
Discussion started by: yayati
2 Replies

10. Shell Programming and Scripting

Finding the time difference

Hi, I have two files A.txt and B.txt. And i have the following attributes in both the files. <date and time> <a unique id> For eg: <2007 May 30 20:29:36:034 GMT> <ID1> in A.txt <2007 May 30 20:42:36:038 GMT> <ID1> in B.txt Now, i need to find the time difference... (0 Replies)
Discussion started by: padma.raajesh
0 Replies
Login or Register to Ask a Question