Skip to content

Instantly share code, notes, and snippets.

@terrancesnyder

terrancesnyder/oracle_jp_date.sql

Created August 20, 2011 16:40
Show Gist options
  • Save terrancesnyder/1159314 to your computer and use it in GitHub Desktop.
Save terrancesnyder/1159314 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle SQL Get Date in Japanese
Raw
oracle_jp_date.sql
SELECT TO_CHAR(to_date('28-06-2011', 'DD-MM-YYYY'), 'Month', 'nls_date_language=japanese') AS b FROM dual;
-- 6月
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment