09 May 2012
Cast('2012-01-20 02:32:37.000000' as Timestamp(6));
Regards...
26 Jun 2012
The TIME and TIMESTAMP data types have a number (from 0 to 6) of fractional seconds in the seconds field which can be specified or defaults to 6 .
Cheers!
d3V1L
Experience is what we get, when we don't get what we want!
You must sign in to leave a comment.
Hello,
I'm very much new to Teradata and writting queries as such. I have a CHAR Type column which contains data as follows
'2012-01-20 02:32:37.000000'.
How do I convert this CHAR type data to DATE Type, preferably as a timestamp?
Regards,
ASR