Load clm with 12 hour time format

Database
Enthusiast

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

1 REPLY
Enthusiast

Re: Load clm with 12 hour time format

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