Archives of the TeradataForum

Message Posted: Thu, 10 Oct 2002 @ 20:21:50 GMT

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

Try this

select (date - cast('2002-01-01' as date));

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