Default date format

From: Tommy Wareing <p0070621_at_oxford-brookes.ac.uk>
Date: 30 Jun 1993 05:09:37 -0500
Message-ID: <C9FIsK.5Fn_at_uk.ac.brookes>


Does anyone know of a wya to change the default date format from DD-MON-YY? All the applications we're now writing have to cope with possible dates after the year 1999, and so our code has TO_CHAR(date, 'DD-MON-YYYY') or TO_DATE(char, 'DD-MON-YYYY') littered through it?
Why don't oracle have a system-wide date format, eg. in the config.ora file, so each database instance can use it's own
date representation?

--
  _________________________   ________________________________
 /  Tommy Wareing          \ /  Dying ain't much of a living, \
|  p0070621_at_uk.ac.brookes   X   When you're out and on the run,|
 \  0865-483389            / \  Dying ain't much of a living,  |
  ~~~~~~~~~~~~~~~~~~~~~~~~~   \ When you're young             /
                               ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Wed Jun 30 1993 - 12:09:37 CEST

Original text of this message