Re: 2000 AD - Oracle Date Format

Erik Lindquist wrote:
>
> Just wondering... Currently the default date format for Oracle is
> DD-MON-YY. What will happen in the year 2000 if I query the database
> like this:
>
> SELECT...
> FROM ...
> WHERE DATE_COLUMN = '22-MAR-96'
>
> Is this date going to evaluate to the year 1996 or 2096?
>
> Anyone know? Thanks.
>
> -Erik. elindquist_at_logicon.com

One possible solution is use of RR format. For details, refer to page 433 of Oracle PL/SQL Programming by Steven Feuerstein. It is one of the best Oracle related book, every serious Oracle user must have.

Joseph. Received on Sun Mar 24 1996 - 00:00:00 CET