Re: Changing default Date format in Oracle 6

trwAT_at_ATmedicalert.DOTorg (Tim Witort ) wrote: [snip]
>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

BTW, remember since v6 you have the NLS (National Lang. Support) option(s) with the INIT.ORA (instance) as well as session parameters, e.g., NLS_DATE_FORMAT, for example: Alter Session Set NLS_DATE_FORMAT = 'DD.MON.YY';

good luck,

                      \\///
                      (0-0)
           +----oOO----(_)-----------+
           |       K. E. Fein        |
           |    Database Analyst     |
           |   kfein_at_primenet.com    |
           +------------------oOO----+
                     |  |  |
                     |__|__|
                      || ||
                     ooO Ooo