OK What's up with this?? I'm creating daily partitions for an oracle table, and using the '+1 days' increment feature of 'date' but one day in particular WON'T increment!!! Here's what the script does with Nov 3, 2007: (NOTE: the +1 days function only works with the date in yy-mm-dd format)
Code:
$ D=071103
$ echo $D
071103
$ D_DATE=`date +"%Y-%m-%d" -d "$D"`
$ echo $D_DATE
2007-11-03
$ date -d "$D_DATE"
Sat Nov 3 00:00:00 EDT 2007
$ NEXT_DAY=`date +"%y%m%d" -d "$D_DATE +1 days"`
$ echo $NEXT_DAY
071104
OK fine, Nov 3rd became Nov 4th, just like we wanted. Now watch on Nov 4 (and note that the date is incremented only 23 hours ahead!)
Code:
$ D=071104
$ echo $D
071104
$ D_DATE=`date +"%Y-%m-%d" -d "$D"`
$ echo $D_DATE
2007-11-04
$ date -d "$D_DATE"
Sun Nov 4 00:00:00 EDT 2007
$ date -d "$D_DATE +1 days"
Sun Nov 4 23:00:00 EST 2007
$ NEXT_DAY=`date +"%y%m%d" -d "$D_DATE +1 days"`
$ echo $NEXT_DAY
071104
Nov 4th plus one day is Nov 4th!!! Whats up with that????
John F
date increment not working on certain dates
