How to substract exactly one month

Database

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

1 REPLY
Junior Contributor

Re: How to substract exactly one month

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