Xref: alice comp.databases.oracle.misc:50272
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.mathworks.com!cam-news-hub1.bbnplanet.com!washdc3-snh1.gtei.net!news.gtei.net!paloalto-snr1.gtei.net.POSTED!not-for-mail
Message-ID: <386E86C7.9D3C414D@cc.gatech.edu>
From: Paul Bennett <bennett@cc.gatech.edu>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: dd/mm/yy - fixed default?
References: <3857a870@eeyore.callnetuk.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 19
X-Trace: /wObnc/4JedN+IL6tl7HgLOAPft8Q6tsmBXXI1cwcxI1Ug3HgDMC7YfLLokHsiikUY3rIqtFMblA!JNyufnIDkIDpcgOVGaenW+nLu58RT62d3Peb63Jn6dPJvlvqnT1ubW8=
X-Complaints-To: abuse@gte.net
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
NNTP-Posting-Date: Sat, 01 Jan 2000 22:58:26 GMT
Distribution: world
Date: Sat, 01 Jan 2000 22:58:26 GMT

It may not be necessary to change anything in your scripts.  The format is just
a display format, so as long as the readers know that 01/01/00 is 2000 and not
1900, you shouldn't need to change anything.  Oracle's internal representation
stores the 4 digit date, so

IF date_var1 < date_var2

will work just fine, even though you may display the dates to the user in
mm/dd/yyyy.

-- Paul

james wigley wrote:

> Is it inevitable that and SQL scripts which queries a date field in an
> Oracle database will return with the format dd/mm/yy, unless the to_char(,)
> function is used - or is there a global default or setting that will prevent
> me from having to update a load of old scripts?