Substitute for "RRMM" of ORACLE in HANA

[former_member197081]

I want to perform a to_date function on a string e.g 9906 to get the output as 199906. This is possible in Oracle using TO_DATE('9906',''RRMM''). But in HANA I didn't find such option. While using YYMM I'm getting the output as 209906 which is not desirable. Please suggest.

[former_member197081 · Accepted solution]

YYMM is actually giving the right output now. E.g 4906 will give June 1, 2049 and 5006 as June 1, 1950