Path: news.easynews.com!easynews!news-xfer.siscom.net!news2.euro.net!transit.news.xs4all.nl!not-for-mail From: "Xavier Neys" Newsgroups: comp.databases.oracle.misc Subject: Re: Date problems Date: Wed, 10 Oct 2001 10:06:56 +0200 Organization: XS4ALL Internet BV Lines: 43 Message-ID: <9q102t$kj0$1@news1.xs4all.nl> References: <9q0rkv$da7$1@wanadoo.fr> Reply-To: "Xavier Neys" NNTP-Posting-Host: a213-84-38-136.adsl.xs4all.nl X-Trace: news1.xs4all.nl 1002701725 21088 213.84.38.136 (10 Oct 2001 08:15:25 GMT) X-Complaints-To: abuse@xs4all.nl NNTP-Posting-Date: 10 Oct 2001 08:15:25 GMT X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Xref: easynews comp.databases.oracle.misc:70107 X-Received-Date: Wed, 10 Oct 2001 04:23:02 MST (news.easynews.com) Bonjour, It took you a while to realize that :-) I suppose your problem is that dates are input as DD/MM/YY and stored with current century. Hence the 99 is stored as 2099. You should and should have done that a long time ago use YYYY and have your users enter 4-digit dates to make sure there is no misunderstanding. Alternatively you can use the format DD/MM/RR instead. I believe Oracle set the window at 49. So 00-49 becomes 20xx and 50-99 becomes 19xx. Hope this helps, Bonne chance, -- Today, Tomorrow, Together The DOC (The Dutch Oracle Company) www.thedoc.nl Xavier Neys PS: you should sign you messages. I usually do not answer to anonymous letters, but [entre francophones] I can make an exeption. "Cefio" wrote in message news:9q0rkv$da7$1@wanadoo.fr... > Hi > > I am working under Oracle version 7.3 and i have a table containing a date > field. > Since year 2000, all records with an year 99 are interpreted 2099 inspite of > 1999. > Can i resolve this problem ?? > If yes where in Oracle must i do the modification ?? > > Thanks. > > > >