I have data like these .
|Mar 22, 2016 12:06:35 PM|
and Data of Datatype Money as 50,000
n my XLXS export Dump .
I need to get these into Teradata table using SQL Assistant.
For now I have Loaded them into a ALL VARCHAR table.
But I need to Get them into tables with Proper DataType table like Timestamp(6) and for Money Datatype(I'm using Decimal(19,10)).
So how do I cast a timestamp column like that ?
any other solution/method you guys can provide ?
Any tips or Sugesstion would be of great help.
select cast('Mar 22, 2016 12:06:35 PM' as TIMESTAMP format 'm3bdd,by4bHH:MI:SSbT')