Tags for two digit year
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')
sql date time timestamp two digit year database time format
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
database sql date time timestamp year two digit year