Re: HELP! Default date format in SQL*Plus isn't dd-mon-yy!

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 26 Feb 2003 12:44:19 +0100
Message-ID: <b3i9aa$iqh$1@dackel.pdb.sbs.de>

"R" <R_at_R.R> wrote in message news:VQ07a.89448$na.1732862_at_news2.calgary.shaw.ca...
> Hi!
>
> I'm in a bind here. Doing some schoolwork and for some reason the default
> date format produced by SQL*Plus is not the expected dd-mon-year, but
> YY-MM-DD. I've tried altering the settings in my Date/Time control panel
> with no success.

That's correct. There is no dd-mon-year format. What oracle gives you is the date format according to ISO8601 Section 5.2.1.3. Please do not use dd-mon-year. If you can't use the ISO format, then change the separators to something else, like periods or whatever is accepted in your country.

You can have a look at the first edition of the standard at http://ulita.ms.mff.cuni.cz/pub/iso/8601/8601.pdf

A few ideas behind the standard are covered in http://www.cl.cam.ac.uk/~mgk25/iso-time.html

Oh, and btw, cern.oracle is not a global group and comp.database.oracle doesn't exist.

Greetings!
Volker Received on Wed Feb 26 2003 - 05:44:19 CST