Re: dd/mm/yy - fixed default?

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: Sat, 01 Jan 2000 22:58:26 GMT
Message-ID: <386E86C7.9D3C414D@cc.gatech.edu>

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?
Received on Sat Jan 01 2000 - 16:58:26 CST