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.

"Jorge Rivero" <jorgerivero@mi.cl> wrote in news:41d84151@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'
/

I think mention of the to_char function which can be used to format the
date value into almost any desired output format is also in order

to_char(date_value.'format string')

and for input to the database see to_date(:variable,'format')

See the SQL manual for all the possible format options
HTH -- Mark D Powell --