Archives of the TeradataForum

Message Posted: Wed, 31 Dec 2003 @ 17:09:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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');

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>