Archives of the TeradataForum

Message Posted: Wed, 07 Sep 2011 @ 07:45:00 GMT

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

This should solve your problem

     SELECT CAST(CAST(('2011-09-07' ||' '|| '10:57:31') AS VARCHAR(20) )
        AS TIMESTAMP(6)) - INTERVAL '06' HOUR 2011-09-07 04:57:31.000000

Regards,

Amogh Badnikar

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