Skip to Content

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 04, 2016 at 05:25 PM

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

    Add comment
    10|10000 characters needed characters exceeded