Archives of the TeradataForum
Message Posted: Wed, 31 Dec 2003 @ 17:09:32 GMT
Swarnapuri, Vinod wrote:
No, just think about which date you'd expect for ADD_MONTHS(DATE '2003-11-29', -1), '2003-10-30'?
If you want to calculate the last day of the previous month:
DATE '2003-11-30' - EXTRACT(DAY FROM DATE '2003-11-30');
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|