Re: Default Date Format
From: Bob Treumann <btreuman_at_cronus.empros.com>
Date: Thu, 21 Apr 1994 22:10:12 GMT
Message-ID: <CoMqx0.11Au_at_empros.com>
Received on Fri Apr 22 1994 - 00:10:12 CEST
Date: Thu, 21 Apr 1994 22:10:12 GMT
Message-ID: <CoMqx0.11Au_at_empros.com>
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 homefax : (612) 489-0128
Received on Fri Apr 22 1994 - 00:10:12 CEST