Re: Which default date format for Y2K

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 11 Jan 1999 13:08:49 +0800
Message-ID: <36998761.3C4A@bhp.com.au>

UK FAN wrote:
>
> What ver. of Oracle are you running?
>
> dbnerd wrote in message <3696C501.865BC04E_at_erols.com>...
> >We are considering changing our database default date format from
> >DD-MON-YY to DD-MON-YYYY or YYYYMMDD. Is there a recommended default
> >date format to make it Y2K compliant?
> >
> >Bob
> >

Oracle itself is Y2K whatever format you choose - HOWEVER I would strongly recommend 4 digit years...when it comes to Oracle converting strings implicitly to dates and vice-versa - it may save you some grief...

Common ones would be:

dd.mm.yyyy
dd-mon-yyyy

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Sun Jan 10 1999 - 23:08:49 CST