All Forums Database
balu_td 22 posts Joined 03/13
29 Mar 2013
Load clm with 12 hour time format

Hi
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
 
Thanks
Balu
 

KS42982 137 posts Joined 12/12
29 Mar 2013

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')

You must sign in to leave a comment.