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

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

RE: DATE 5th OCT, 1582 not coming

From: Afanassiev, Alex <Alex.Afanassiev_at_team.telstra.com>
Date: Wed, 18 Oct 2000 12:27:02 +1100
Message-Id: <10652.119575@fatcity.com>


Hi Sanjeev

It might still work in Russian Orthodox version of Oracle :)

With regards
Alex Afanassiev
Oracle DBA, TOC OPS/Internet.Operations

Tel:	(03) 8 661 20 61
Fax:	(03) 9 650 36 74



> -----Original Message-----
> From: Sanjeev Sachdeva [SMTP:sanjeevs_at_delhi.tcs.co.in]
> Sent: Wednesday, October 18, 2000 2:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sanjeev Sachdeva
> INET: sanjeevs_at_delhi.tcs.co.in
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Oct 17 2000 - 20:27:02 CDT

Original text of this message

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