Archives of the TeradataForum

Message Posted: Tue, 18 Aug 2009 @ 11:22:18 GMT

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

Please try with DAY(4)

     SEL CAST(((DATE - DATE '2008-07-01') DAY(4)) AS FLOAT)*24*60*60

Thanks

Anand

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