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: Y2k and dates

Re: Y2k and dates

From: johnkoo <johnkoo_at_i-wave.net>
Date: Thu, 6 May 1999 20:51:10 +0100
Message-ID: <7grvs2$h8q10@news.hk.linkage.net>


Should be simple here:
Make sure you set NLS_DATE_FORMAT='DD-MON-RRRR' in your init.ora. (Actually, NLS_DATE_FORMAT='DD-MON-RR' will also work fine.) But everything depend on how you code your program !!!

John K.

MesterLars wrote in message <3730321F.2974AB00_at_knold.ballehs.dk>...
>I have created a table with a date parametre. It seems like the
>date-type stores information like 01-jan-99. But I want to store it like
>01-jan-1999. It is very important for the application I am developing.
>Thanks
>
>Lars Berg
>
Received on Thu May 06 1999 - 14:51:10 CDT

Original text of this message

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