Days difference between two dates

Data469 · #1 (**permalink**) 03-10-2008

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.

jim mcnamara · #2 (**permalink**) 03-10-2008

try this to start - note you have to handle cross-years eg 2007 -> 2008

Code:

#!/bin/ksh
yday()
{
        perl -e '
                use POSIX qw(strftime);
                $fmt = "%j";  # %j day of year 1 - 366
                $mday = substr("$ARGV[0]", 8, 2);
                $mon =  substr("$ARGV[0]", 5 ,2);
                $year = substr("$ARGV[0]", 0 ,4);                  
                $weekday =
                  strftime($fmt, 0, 0, 0, $mday , $mon - 1, $year - 1900, -1, -1, -1);
                print int $weekday;
                ' "$1"
}

today=$( yday 2008-03-10 )
oldat=$( yday 2008-01-03 )
ddiff=$(( $today - $oldat ))
echo "$ddiff"

ali560045 · #3 (**permalink**) 03-11-2008

thanks a lot. this is really so helpfull to me...........i will never forget your help in this

jaduks · #4 (**permalink**) 03-11-2008

A handy one :-)

Code:

$ cat daysdiff.sh
D1=`date +%s -d "2007-12-19"`
D2=`date +%s -d "2008-02-09"`
((diff_sec=D2-D1))
echo - | awk -v SECS=$diff_sec '{printf "Number of days : %d",SECS/(60*60*24)}'

//Jadu

Data469 · #5 (**permalink**) 03-26-2008

Thanks a lot for the replies.

But, I use HP-UX and it does not support date %s. Hence I need a different way to find the difference between the dates in a shell script.

era · #6 (**permalink**) 03-26-2008

Do you have Perl? [innocent glance]

Data469 · #7 (**permalink**) 03-26-2008

No I do not have Perl. This needs to be strictly in ksh.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Number of days between two distinct dates	radheymohan	UNIX for Advanced & Expert Users	1	10-16-2007 08:39 AM
Find number of days and list out the dates in between	Raynon	Shell Programming and Scripting	2	02-12-2007 08:52 PM
Difference between two dates in no of days ???	csaha	Shell Programming and Scripting	1	01-13-2006 06:44 AM
Difference between two dates...	rajus19	Shell Programming and Scripting	4	01-04-2006 04:53 AM
days elapsed between 2 dates	rkkiran	UNIX for Dummies Questions & Answers	1	03-04-2002 12:45 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by