Date Difference


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Date Difference
# 1  
Old 03-04-2020
Date Difference

Hello Guys,

I am trying to find the difference between two dates & need to assign that value in a variable for further code. I am able to find the difference but have some issues with it.
1. Value is coming in decimal point ( 82.95833333333333333333 ) which should be actually 83 days
2. I am able to print the difference with echo command but when I assign it to some variable it fails.

Can someone please take a look at it & help to sort out ? below is the code I am using now :

Code:
Code:
Date1=2020-05-26
Date2=2020-03-04

Code:
echo "`date -d $expdate +%s` - `date -d $today +%s`)/(24*3600)" |bc -l

If I try to store a value in a variable called Diff="`date -d $expdate +%s` - `date -d $today +%s`)/(24*3600)" |bc -l
it fails.
# 2  
Old 03-04-2020
Hi
How about install dateutils ?
Code:
datediff 2020-03-04 2020-05-26
83

These 2 Users Gave Thanks to nezabudka For This Post:
# 3  
Old 03-04-2020
I recommend to use awk instead of bc to calculate here, because bc displays floating point numbers <1 without a leading zero.

So your command ...

Code:
echo "`date -d $expdate +%s` - `date -d $today +%s`)/(24*3600)" |bc -l

becomes ...

Code:
awk -vd1="$(date -d "$expdate" +%s)" -vd2="$(date -d "$today" +%s)" '  'BEGIN { printf "%.0f\n",(d1-d2)/(24*3600) }'

I generally recommend $(...) instead of `...` for command substitution since different single quotes can be easily mixed up and easy nesting is only possible with the braces.

Note especially the printf command within awk. It accomplishes the rounding.

To get it into a variable you have to use another command substitution:

Code:
varname="$( ... command ... )"


Last edited by stomp; 03-04-2020 at 06:04 AM..
# 4  
Old 03-04-2020
How about
Code:
printf "%s\n" $(( ($(printf "%d\n" ${Date1//-} ${Date2//-} | date -f-  +"%s-") 0+43200) / 86400 ))
83

# 5  
Old 03-04-2020
Thanks RudiC,

It works & gives correct value as well.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Difference between two date

Hi, I created a script for finding the duration of a job using the start and end time of the job. But the command doesnt calculate correct value if the duration is more than 24 hours. Any help would be really good . cat test1 --- start time 03/27/15 17:41:00 03/24/15 11:58:04 03/23/15... (3 Replies)
Discussion started by: rogerben
3 Replies

2. AIX

Time Difference between date and date -u

Hi Everyone, We are having an issue with date and date -u in our AIX Systems. We have checked environment variable TZ and /etc/environment and however, we could not rectify the difference. >date Thu Mar 19 22:31:40 IST 2015 >date -u Thu Mar 19 17:01:44 GMT 2015 Any clue... (5 Replies)
Discussion started by: madhav.kunapa
5 Replies

3. Shell Programming and Scripting

Date difference

HI All , i need a bash script to find the number of days between two dates . Format YYYY-MM-DD THanks, Neil (1 Reply)
Discussion started by: nevil
1 Replies

4. Programming

Date difference

I tried the below code to find difference between two dates. It works fine if the day of the month is 2-digit number. But it fails when we have a single-digit day of month(ex:1-9). my code is as below. please help me soon. #!/usr/bin/perl -w use strict; use Time::Local; ... (2 Replies)
Discussion started by: anandrec
2 Replies

5. Homework & Coursework Questions

help with the date difference

1. The problem statement, all variables and given/known data: The problem i have is that i probably make a few mistake here in the code but don't know what it is and i try to get the date difference but don't know where to add the days_in_month function 2. Relevant commands, code,... (1 Reply)
Discussion started by: mgyeah
1 Replies

6. Shell Programming and Scripting

Difference in date

Dear all, I fancy that I'm pretty competent in ksh, but I have someone on HP-UX wanting me to script up a simple interface to handle user alterations rather than giving them high privileges to run up SAM. This is all fairly straightforward, but I'm stuck on an epoch date issue. When we have... (6 Replies)
Discussion started by: rbatte1
6 Replies

7. Shell Programming and Scripting

difference in date

Hi All! I would like to know the time difference between two dates which are in same format... $ date -r abc Thu Oct 29 09:40:37 EDT 2009 $ date Fri Oct 30 02:07:03 EDT 2009 i would like to find the diff between these two dates in hours..please help..:) Regards, Kiran (3 Replies)
Discussion started by: dddkiran
3 Replies

8. Linux

date difference

hi, i have 2 dates in the form: '20080315120030' and '20080310140030'. i.e. YYYYMMDDHHMMSS. i need a way of getting the difference between them using shell script. any thoughts? (14 Replies)
Discussion started by: muay_tb
14 Replies

9. Shell Programming and Scripting

date difference

if there are two date one is entered by user and another is system date than how can we finds day difference between these two date try to make it within 4 lines (2 Replies)
Discussion started by: piyush_movadiya
2 Replies

10. UNIX for Dummies Questions & Answers

date difference

Hi Can any buddy give mi a simple program or logic or command which will get difference between two dates ex:diff between 20051008 2005908 is 24hours 12 min 2 sec regards (1 Reply)
Discussion started by: rajuMBT
1 Replies
Login or Register to Ask a Question