Archives of the TeradataForum

Message Posted: Wed, 07 Sep 2011 @ 08:29:55 GMT

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

it seems to be simplest :

     select cast( cast(TRANSDATE as format 'yyyy-mm-dd' )   || ' ' ||
     cast(TRANSTIME -60000 as  format '99:99:99' ) as timestamp(0))

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