Tags for 24 hour time
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  
sql mload teradata date timestamp AM PM 12 hour time 24 hour time time