Re: Format Date in database

"Jorge Rivero" <jorgerivero_at_mi.cl> wrote in news:41d84151_at_news:

> Hi,
>
> I need change the format of date in my database, my format is
> (dd-mm-yyyy) and i like (dd/mm/yyyy), thanks and sorry for my English.

DATE data type is stored in the database without ANY format.

Some variation of the following should solve your problem.

alter session set nls_date_format='dd/mm/yyyy' / Received on Sun Jan 02 2005 - 13:03:46 CST