I'm very much new to Teradata and writting queries as such. I have a CHAR Type column which contains data as follows
How do I convert this CHAR type data to DATE Type, preferably as a timestamp?
Cast('2012-01-20 02:32:37.000000' as Timestamp(6));
Thanks a lot Alvie.
What does the (6) in the parenthesis indicate?
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 .
Experience is what we get, when we don't get what we want!