Timestamp format not working to get the two digit year

Database

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

1 REPLY

Re: Timestamp format not working to get the two digit year

Intersting thing is in above eg is date you can "19"

12/12/1912 00:00:00