All Forums Database
balu_td 22 posts Joined 03/13
06 Mar 2013
Timestamp format not working to get the two digit year

Hi
My Source data has only two digit year when i am trying to convert to timestamp
sel cast('12/12/12 00:00:00' as timestamp(0) format 'MM/DD/YYBHH:MI:SS')
o/p
12/12/1912 00:00:00
tried with the current_timestamp(0)
eg:
sel cast(current_timestamp(0) as timestamp(0) format 'MM/DD/YYBHH:MI:SS')
o/p
3/6/2013 12:09:59
 
 

balu_td 22 posts Joined 03/13
06 Mar 2013

Intersting thing is in above eg is date you can "19"
12/12/1912 00:00:00

You must sign in to leave a comment.