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

Home -> Community -> Usenet -> c.d.o.server -> Re: Y2K Support in Oracle?

Re: Y2K Support in Oracle?

From: Richard Ji <guile_at_escape.com>
Date: 1998/06/01
Message-ID: <357301f1.22300676@newshost.us.oracle.com>#1/1

On Fri, 29 May 1998 11:22:42 GMT, meyer_b_at_my-dejanews.com wrote:

>Does Oracle Server 7.3.3, (or SQL+ 3.3) offer any support for Y2K issues other
>than the RR date format option?
>
>I know it how Oracle stores dates internally, and I know I can format dates
>with the full 4 digit year. What I want to know is, if I have users who don't
>wish to enter a 4 digit year, does Oracle offer any built in support for
>century determination?
>

Well, assuming you are not using RR in NLS_DATE_FORMAT. Oracle defaults to your default century when only supplied by 2 digit year. And the way Oracle gets the default century is from the OS. So if you change your system clock to 20xx already and only supply two digit year, you will see 20xx being inserted.

>Thanks,
>
>Bob
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Jun 01 1998 - 00:00:00 CDT

Original text of this message

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