Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Substitute for "RRMM" of ORACLE in HANA

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.


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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question