| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Wrong century in SQL statements
I think you can do something about this by setting your default date format to dd-mon-rr instead of dd-mon-yy. Look at the NLS_DATE_FORMAT initialization parameter in your Oracle8i Reference manual, and at the date format specifications in your SQL Reference manual. Be sure to test things out on a test database first. I was lucky, and never had to worry about this. Our apps were all converted before the date change to use 4-digit years only.
Jonathan
On Tue, 23 May 2000 14:11:13 -0500, "GH" <gh_at_yahoo.com> wrote:
>Hi All,
> I've inherited a database with over a thousand SQL procedures and we've
>recently run into a little problem with a few statements due to the date
>format. The dates in the SQL statements are formatted as dd-mmm-yy. I think
>some of the years are being read as 20yy. Does Oracle have a sliding date
>window? I would like to be able to set something to tell it that any year
>over 80 should be in the 1900s, and not the 2000s. And I really don't want
>to change a whole bunch of SQL statements. Thanks in advance for any help.
>
>
Received on Wed May 24 2000 - 00:00:00 CDT
 |
 |