Re: dd/mm/yy - fixed default?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 15 Dec 1999 17:48:13 +0800
Message-ID: <385763DD.172A@yahoo.com>

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?

Look at setting your database date format to 'rr' in place of 'yy'...In this way, all those "old" formatted dates will still be ok...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 15 1999 - 03:48:13 CST