All Forums Database
sudhakar1987 2 posts Joined 03/12
01 Jun 2015
How to substract exactly one month

If date is 2015-02-28 i need it as 2015-01-31
 
Add_Months(2015-02-28,-1) isn't working

dnoeth 4628 posts Joined 11/04
01 Jun 2015

If this is correct or not depends on the definition of "exactly one month" :-)
 
You might want Oracle's definition:
oAdd_Months(2015-02-28,-1)
is supported in TD14

Dieter

You must sign in to leave a comment.