Re: Change default DATE format???

Use
alter session set nls_date_format = 'DD-MON-YY HH24:MI:SS'; to include time also in the date. This will only change it for the session. If you create a login.sql and put the above statement then every time you start sqlplus from the directory having the login.sql you will the date format set automatically.

raghuvir

Jacques Sireude <sireude_at_eiffel.com> wrote in article <6nepca$ago$1_at_news.rain.org>...
> How can I change the default format of the Date type???
>
> My sql statement is "select * from db_book" and I want to see the date
with
> another format than the default one...
>
> thanks for any help...
>
> Or is there a way to retrieve the binary code of the date from an OCI
> application???
>
> Jacques
>

> ----------------
> Jacques SIREUDE
> 6585 PICASSO Rd Apt#3
> ISLA VISTA CA 93117
> USA
> tel/fax: 1-805-685-9208
> e-mail: sireude_at_eiffel.com
> jacques.sireude_at_enst-bretagne.fr
> http://www-eleves.enst-bretagne.fr/~sireude
>

> ----------------
>
>
>
>
Received on Fri Jul 03 1998 - 13:29:50 CDT