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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date format RR limitations. (adding; Please answer, Thomas Kyte!)

Re: Date format RR limitations. (adding; Please answer, Thomas Kyte!)

From: dhmac <dhmac_at_JUSTREMOVETHISmy-dejanews.com>
Date: Wed, 3 Mar 1999 23:10:04 -0500
Message-ID: <7bl11o$ee2$1@camel21.mindspring.com>


Arjan van Bentem wrote in message <36dcd363$0$13308_at_pascal>... [...]
>
>See above. It does *not* matter. Oracle always stores the dates fully Y2k
>compliant (and has done since a long time), regardless whether it is in the
>14th or 22nd century. It just is inputting two-digits years that gives you the
>problem. Using RR, or even better RRRR for the input mask just helps you to
>get the dates into the database. However, it is really a nice add-on to help
>make your apps Y2k compliant. New apps should definitly use YYYY.
>

I know how RRRR works, but how does YYYY handle 2-digit years? Received on Wed Mar 03 1999 - 22:10:04 CST

Original text of this message

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