Date - incorrect results for previous date


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date - incorrect results for previous date
# 1  
Old 04-28-2014
Date - incorrect results for previous date

Hello:
I am bit puzzled with what I could be doing wrong and any help is appreciated.
I have a date in YYYMMDD format and I need to find the previous date. Based on the input on this forum, I have come up with the following. It seems to work for all except the following. Here I am passing date "20140310" and my expected output is "20140309" but I am getting "20140308". Bit weird....

Code:
$ date -d 20140310 +%s
1394424000
# now deduct 86400 sec for 24 hours
$ expr 1394424000 - 86400
1394337600
$ date +"%Y%m%d" -d @1394337600
20140308

# 2  
Old 04-28-2014
I suspect time zones are involved. TZ="GMT" date ...
This User Gave Thanks to Corona688 For This Post:
# 3  
Old 04-28-2014
It's probably related to daylight savings adjustments.

Try specifying Timezone to UTC for each data command:

Code:
$ TZ=UTC date -d 20140310 +%s
1394409600
$ expr 1394409600  - 86400
1394323200
$ TZ=UTC date +"%Y%m%d" -d @1394323200
20140309

This User Gave Thanks to Chubler_XL For This Post:
# 4  
Old 04-28-2014
Quote:
Originally Posted by Corona688
I suspect time zones are involved. TZ="GMT" date ...
Hmm. If I am in a EST with daylight savings observed, what needs to be changed to the above. I use this logic for a set of dates and 20140310 is just n example

---------- Post updated at 04:32 PM ---------- Previous update was at 04:28 PM ----------

Thanks carnoa and chuber, that fixes
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Not able to fetch previous month first date and last date

I am not able to fetch first date and last date previous month date -d -1month +%Y-%m-%d date -d -1month +%Y-%m-%d I need two format dd-mm-yyy previous month 01-03-2016 previous month 31-03-2016 and also only date 1 to 31 Aprriciate your replay (4 Replies)
Discussion started by: jagu
4 Replies

2. Shell Programming and Scripting

Script to get previous date for the given input date..

hi all, need a script or command to get the previous date for the given input date... like in my script i will pass date as input parameter like 2014-12-01 and i want the output as previous date.. ie.. 2014-11-30 (2 Replies)
Discussion started by: hemanthsaikumar
2 Replies

3. Shell Programming and Scripting

Help with getting last date of previous month and first date of previous 4th month from current date

I have requirment to get last date of previous month and the first date of previous 4th month: Example: Current date: 20130320 (yyyymmdd) Last date of previous month: 20130228 (yyyymmdd) First date of previous 4th month: 20121101 (yyyymmdd) In my shell --date, -d, -v switches are not... (3 Replies)
Discussion started by: machomaddy
3 Replies

4. Shell Programming and Scripting

Get Previous date of a past date

Hi all, I have a variable where it has a past date value in the format YYYY-MM-DD eg-> pcontromModate="2008-11-31" How can i get the date 1 day before the pcontromModate. The required date is 2008-11-30. ..Plz reply since its an urgent one (2 Replies)
Discussion started by: morbid_angel
2 Replies

5. Shell Programming and Scripting

Get Previous date from a given date

Hi all, I have a variable where it has a date value in the format YYYY-MM-DD eg-> pcontromModate="2010-11-31" How can i get the previous date of pcontromModate in the format YYYY-MM-DD (3 Replies)
Discussion started by: morbid_angel
3 Replies

6. 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

7. Shell Programming and Scripting

Pass the first date and last date of previous month

Hi All, I need to run a job every month at the beginning of the month which is scheduled through autosys, lets say on 03/01/2010. I need to pass the last month's i.e February's first_date = 02/01/2010 and last_date = 02/28/2010 as variables to a stored procedure. Can somebody please pass... (2 Replies)
Discussion started by: vigdmab
2 Replies

8. Shell Programming and Scripting

want to get previous date from date command in ksh

I want to get previous date from date command. I am using ksh shell. Exmp: today is 2008.09.04 I want the result : 2008.09.03 Please help. Thanks in advance. (4 Replies)
Discussion started by: rinku
4 Replies

9. Shell Programming and Scripting

Specify a previous date as start date in shell script

Hi, I am trying to modify a script which accepts date in format dd/mm/yy. I am trying to modify the script so that it retrieves the date that was 15 days earlier from today as start date. Eg.if today is 05/09/2006, the script should retrieve 21/08/2006 as start date. Is there any script/code to... (2 Replies)
Discussion started by: ritzwan0
2 Replies

10. UNIX for Dummies Questions & Answers

How to find Previous date and Coming date

Hi All, How to find a date which is 7 days from the current date as well as how to find a date which is 7 days before this current date. Urgently i need help. Thanks in Advance Regards Arunava (2 Replies)
Discussion started by: arunava_maity
2 Replies
Login or Register to Ask a Question