Convert time '0300' in varchar format to Timestamp by appending current_date to time

Database

Convert time '0300' in varchar format to Timestamp by appending current_date to time

Hi,

 I need help in converting  time '0300' (3 AM) which is  in varchar format to Timestamp(6) by appending current_date to time(2015-01-23 03:00:00)

Thanks,

 Irf

1 REPLY
Senior Apprentice

Re: Convert time '0300' in varchar format to Timestamp by appending current_date to time

Hi Irf,

select cast('0300' as timestamp format 'hhmi')