Archives of the TeradataForum

Message Posted: Fri, 26 Oct 2012 @ 20:20:12 GMT

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

Below might be simpler....

     SELECT CAST('12032012 02:23:45' AS TIMESTAMP(0) FORMAT 'MMDDYYYYbHH:MI:SS'); SELECT CAST
     ('2012-09-25 20:49:59' AS TIMESTAMP(0) FORMAT 'yyyy-mm-ddBhh:mi:ss'); SELECT CAST
     ('20090310181010' AS TIMESTAMP(0) FORMAT 'YYYYMMDDHHMISS');

Thanks

Meher

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