Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 17:05:03 GMT

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

select (date / 100) * 100 + 1 (date)

When run today (October 24, 2001) I get

2001-10-01

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