Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> DATE 5th OCT, 1582 not coming
Here we are using following SQL:
select to_date('5-OCT-1582','DD-MON-YYYY') from dual;
which is returning 15-OCT-1582, instead of 05-OCT-1582
Any Clue ?
Sanjeev Received on Tue Oct 17 2000 - 09:37:21 CDT
![]() |
![]() |