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.

Tags:
replied

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