All Forums Database
irf2008 1 post Joined 01/15
22 Jan 2015
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
 
 
 
 
 

dnoeth 4628 posts Joined 11/04
23 Jan 2015

Hi Irf,

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

 

Dieter

You must sign in to leave a comment.