Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

Difference between two dates

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Difference between two dates
# 1  
Old 03-31-2017
Difference between two dates
Hi There

I am trying to find the difference between two dates in seconds, by taking the first 10 digits of the file name itself, which I have done as shown below:

Code:
current_time=`date +%s`
last_login_of_tim=`date -d @1489662376 +%s`
 diff_sec=$(($current_time-$last_login_of_tim))

This will return the date in seconds.

However what I am stuck with is that the file I want to return the date from, in the name it has the date and time of last execution, I tried to do the same way but this failed.

File Name: 'Wynyard_MTP_Primary-btstats-2017-03-29-10:34:50.xml'

How can I now do what I done before but with this file?

Any help would be greatly appreciated

Thanks in advanced
Last edited by Don Cragun; 04-05-2017 at 03:46 AM.. Reason: Change quote tags to code tags.
# 2  
Old 03-31-2017
Please elaborate how you did "do the same way", and also post the way "this failed".
Where and how is that file name stored? A shell variable? In a loop?

Are you aware that date -d @1489662376 +%s is a NoOP?
# 3  
Old 03-31-2017
Hi RudiC

Sorry yes i will.

So first of all i'm not sure what you mean by a NoOP?

& by meaning same process I mean taking the first 10 digits but as there are "-" between day month year etc it won't except, is there another way to execute this?
# 4  
Old 03-31-2017
NoOp (No Operation) means "do nothing". Look at the result:
Code:
date -d @1489662376 +%s
1489662376

Why didn't you answer ALL questions?
# 5  
Old 04-04-2017
Hi @RudiC

Sorry for the late reply

So yes I have just noticed that this is a no operation, so I want to find the difference between the dates with two files and have a round number (if possible in minutes/seconds)

So for example to days date = date = Tue Apr 4 11:05:18 BST 2017
The date of the particular file = date -d @1489662376 = Thu Mar 16 11:06:16 GMT 2017

Is there away to calculate the difference in minutes or seconds in this case would be roughly 27,359 minutes or 1,641,542 seconds. Is there a way to get this answer?

Thanks
simpsa27
# 6  
Old 04-04-2017
Hi.

See package dateutils, which can be found in many repositories, and includes ddiff:
Code:
NAME
       ddiff  -  Compute  duration from DATE/TIME (the reference date/time) to
       the other

SYNOPSIS
       ddiff [OPTION]... DATE/TIME [DATE/TIME]...

DESCRIPTION
       Compute duration from DATE/TIME (the reference date/time) to the  other
       DATE/TIMEs  given  and  print  the  result  as  duration.  If the other
       DATE/TIMEs are omitted read them from stdin.
...
       Time specs:
         %H  Durations in hours
         %I  Equivalent to %H
         %M  Durations in minutes
         %S  Durations in seconds
...

Some additional details:
Code:
dateutils.ddiff Compute duration from DATE/TIME (the reference date/ti... (man)
Path    : /usr/bin/dateutils.ddiff
Version : 0.3.1
Type    : ELF 64-bit LSB shared object, x86-64, version 1 (S ...)
Help    : probably available with -h,--help
Home    : https://github.com/hroptatyr/dateutils

The package utilities take some practice to learn, but are very useful for dealing with almost any form of date and time data.

Best wishes ... cheers, drl
Last edited by drl; 04-04-2017 at 01:59 PM.. Reason: Correct minor typo (spelling).
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Fedora

Difference of dates

I have a script which is printing date in below format while writing the logs. theDate=`date +"%m%d%Y"` theTime=`date +"%H%M%S"` echo $theDate $theTime How can i find out difference current time and above format. Appreciate your help. (6 Replies)
Discussion started by: srikanth38
6 Replies

2. Shell Programming and Scripting

Difference between 2 dates

Hi Friends, I have a file that has the contents like below: file1.txt 5,13/07/2013 23:25:25,14/07/2013 19:40:21 5,13/07/2013 23:25:25,14/07/2013 19:40:43 5,12/07/2013 23:50:50,13/07/2013 20:30:26 5,12/07/2013 23:20:24,13/07/2013 19:40:53 60,14/07/2013 00:00:00,14/07/2013 23:00:39... (5 Replies)
Discussion started by: vsachan
5 Replies

3. Shell Programming and Scripting

Difference between two dates

hi all, I need a help for below requirement. Difference between two dates"12-11-2009" and "03-25-2012" (mm-dd-yy format") in weeks and days and hours Please help me for this. Thanks in adv.... I am working in AIX, so dont have below command:- date --version (2 Replies)
Discussion started by: gani_85
2 Replies

4. Shell Programming and Scripting

Difference between two dates

Hi! I have two parameters like this: YYYY-MM-DD YYYY-MM-DD My question is, there is a direct command for get the elapsed time between the 2 dates, or I have to find another way? Thx! (1 Reply)
Discussion started by: MalaTomi
1 Replies

5. Shell Programming and Scripting

Calculating the difference between dates

Hello! i need to find files lower and bigger that one date i pass, i search in the man find, but i didn't find anything, the only that i find is the parameter -mtime, in this parameter i can pass a number of days, but i need to know the difference between dates, any built-in function for do... (15 Replies)
Discussion started by: claw82
15 Replies

6. Shell Programming and Scripting

Perl difference between dates

Hi, Is there any way I can get the difference between two dates in terms of days? I have used this method so far, but I cant format it in terms of days. @a=&DateCalc($date1,$date2,0); The o/p that I am getting is sort of like this: +0:0:0:4:0:0:0 I just want to get 4 days as an o/p.... (1 Reply)
Discussion started by: King Nothing
1 Replies

7. Shell Programming and Scripting

Difference between two dates.

Hi all. My question may seems to be similar to one that already been here. But i need a little other solution. I have two dates in format dd/mm/yyyy. I need to find number of days between them. I need to do it in bash script. I am running on Solaris machine and have cutted 'date' command version... (1 Reply)
Discussion started by: kukuruku
1 Replies

8. Shell Programming and Scripting

Days difference between two dates

Hello, I would like to find out the number of days between two dates of the format yyyy-mm-dd. Any help on this is highly appreciated. Thanks. (6 Replies)
Discussion started by: Data469
6 Replies

9. Shell Programming and Scripting

Difference between two dates in no of days ???

Hi All How to get the difference between two dates in no of days ??? My date format is like this YYYY/MM/DD. I have to get the no of days between two dates in the given format. I tried to search the forum but nothing came up similar to my requitement. Your help will be appreciated. ... (1 Reply)
Discussion started by: csaha
1 Replies

10. Shell Programming and Scripting

Difference between two dates...

Hi All, Wish you a Happy New year... I have to find the difference between two dates, the result should be the number of days. I have seen the "datecalc" function. Its good, can I have any other alternative. Thanks in Advance Raju (4 Replies)
Discussion started by: rajus19
4 Replies
Login or Register to Ask a Question