I need to load a file using mload where the load clm has a data like this 03/29/2013 12:00:00 PM.
select cast(cast('03/29/2013 12:00:00 PM' as timestamp(0) format 'MM/DD/YYYYBHH:MI:SSBT') as varchar(22))
I need it to load as Timestamp rather than varchar
What if you remove the cast of varchar ? Like,
SELECT CAST('03/29/2013 12:00:00 PM' AS TIMESTAMP(0) FORMAT 'MM/DD/YYYYBHH:MI:SSBT')