Re: Default Date Format

In Article <2ou4hp$ok1_at_cville-srv.wam.umd.edu>dinguyen_at_wam.umd.edu (Dzi Nguyen) writes:
>Hello Netter,
>Does anyone know how to change the Oracle default date format without using
>to_date, maybe throught an environment variable or some sort?
>

You can't change sysdate, but you can create a view that changes sydate and use that:

  ( Please pardon my psuedo-syntax )
   create view today as
   select to_char(sysdate,<formatting info>) date    from dual;

Now, you can write:
  select date from today;

• and you have date formatted the way you want it.

Solution Engineering Inc.
1290 Osage St North
St Paul Mn 55117-4062

  Bob Treumann                          email:  btreuman_at_empros.com
  phone: (612) 553-4346                 (612)-489-4960 home