Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> DATE 5th OCT, 1582 not coming

DATE 5th OCT, 1582 not coming

From: Sanjeev Sachdeva <sanjeevs_at_delhi.tcs.co.in>
Date: Tue, 17 Oct 2000 20:07:21 +0530
Message-Id: <10652.119462@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US