Archives of the TeradataForum

Message Posted: Fri, 29 Sep 2006 @ 17:41:42 GMT

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

Andrea,

try this:

     sel cast('2006-01-01 10.56:00' as timestamp(0)) ttt
       , cast(cast(ttt as date) as timestamp(0));

Ciao

Sergio

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