CODEWITHSUNDEEP
oracle-databasecjk
Jagadeesh
Jagadeesh

Reputation: 33

How to get the date in japanese format (2008年12月31日) in oracle sql

I have to get the date in japanese format (2008年12月31日) in oracle sql.

I tried select TO_CHAR(sysdate, 'YYYY-MON-DD', 'nls_date_language=''JAPANESE''') FROM dual; But i am getting, 2019-4月 -04 . I am not getting the year and day symbols.

Let me know if there is a way to achieve it in oracle sql.

Upvotes: 2

Views: 1235

Answers (1)

akky
akky

Reputation: 2907

try a format 'YYYY"年"MM"月"DD"日"'

Upvotes: 1

Related Questions