All Forums Database
krishna1985 13 posts Joined 08/16
09 Aug 2016
convert varchar data into timestamp

Hi All,
can you please help me with this
 
I am trying to convert below varchar records into timestamp.
 

 2016-08-03 8:32:03

2016-08-03 11:56:34

 

Tried multiple ways of casting but not ablt to get.

 

Regards,

Krishna

Regards, Hari Krishna
Inguva 4 posts Joined 08/16
10 Aug 2016
sel cast('2016-08-03 08:32:03' as timestamp format'yyyy-mm-ddbhh:mi:ss')

This Worked for me Try once

You must sign in to leave a comment.