Archives of the TeradataForum

Message Posted: Thu, 05 Oct 2000 @ 21:12:41 GMT

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

Try: add_months((anydate-extract(day from anydate)+1),1)-1

This computes the first day of the month, adds one month, then backs up one day.

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