Archives of the TeradataForum

Message Posted: Fri, 28 Feb 2003 @ 03:50:14 GMT

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

sel add_months(date,1) - extract(day from add_months(date,1));

This will give you the last day of the current month.

Sanjaya Kumar G N

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