?Setting System Date Format
Date: Sun, 2 Oct 94 10:52:00 -0500
Message-ID: <12a.5181.905_at_compudata.com>
-> Got a question. We want to change the format for the default date
-> field format from dd-mon-yy to dd-mon-yyyy (the year 2000 is sure
-> going to be fun). Also, so that indexing on date will pick this up.
-> Is this a configurable parameter?
You have confused the default visual date you see (when doing a select with NO to_char()) VS what Oracle actually stores.
Oracle will save the entire MM/DD/YYYY HH:MI:SS if you give the data to it. If you don't (such as saying to_date('09/24/94','mm/dd/'yy') it will default the '19' portion and put the time as 00:00:00 (12 midnight).
There is an init.ora parameter that you can use to change the default visual date (but of course I'm home right now and don't have it). Received on Sun Oct 02 1994 - 16:52:00 CET