Archives of the TeradataForum

Message Posted: Thu, 30 Sep 2004 @ 17:27:15 GMT

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

Try :-

     select cast('2004-09-07 11:57:00.00000' as timestamp(5))
      (format 'yyyy-mm-ddbhh:mi:ss') (char(19));


     select cast('2004-09-07 11:57:00.00000' as timestamp(5))
      (format 'hh:mi:ss') (char(8));

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