Thanks for the question, John.
Asked: August 17, 2017 - 3:21 pm UTC
Last updated: June 14, 2024 - 3:25 am UTC
Version: 11.2.0.4 (maybe older?)
Viewed 10K+ times! This question is
SQL> alter session set nls_date_format = 'DD/MM/YYYY'; Session altered. SQL> select to_date('960504','rrmmdd') from dual; TO_DATE('9 ---------- 04/05/1996
John Low, August 18, 2017 - 11:29 am UTC
Boris Goldberg, June 13, 2024 - 5:14 pm UTC
The Oracle documentation contains a complete SQL reference.