Re: Changing default Date format in Oracle 6

Albert W. Dorrington wrote:
>
> Hi All,
>
> I have an Oracle6 database (V6.0.33.1.4) and have not been
> able to find the answer to this question inthe documentation.
> Is there a method for changing the default date presented
> by the database when selecting from a date field?
> Currently the system returns dates in the format of: 22-JUL-97
> I would like to change the default format to be: 22-JUL-1997
>
> Yes, I know I can use the formatting routines for this, but I would
> like the DEFAULT format to change.

Sorry, v6 and v7 return the date in DD-MON-YY format. You can fake the change with views which do a to_char, but then the retrieved value will be char, not date. I know of no way to change the way a date is presented by default.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||