getdate() SAP ASE 16 SP04 Pl04

[jmtorres]

Good day,

 Running this query in SAP ASE 16.x :

select convert(datetime,'491006'), convert(datetime,'501006')

For '491006' it returns 2049 instead 1949.  Any known issue?

Thank you

Regards

Jose

[Bret_Halford · Accepted solution]

This is the expected documented behavior.

"

• If you specify only the last two digits of the year, values of less than 50 are interpreted as “20yy,” and values of 50 or more are interpreted as “19yy.”

"
See https://help.sap.com/docs/SAP_ASE/b65d6a040c4a4709afd93068071b2a76/aa3d19f7bc2b10148022c62f2db8405e....

cheers,
-bret

[jmtorres · Accepted solution]

thanks Bret.!