Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need to set rmy date format to 'DD/MM/YYYY'
Hi
About your question to Oracle Group :
The command alter session ... only take effect while you're connected. After
that it loss its effect. If you need to keep active this format to your
applications, you must to include the parameters names "nls_date_format =
'DD/MM/YYYY' " into you parameter file. You must
shutdown and startup your database to make this change active. If you don't want
to this format anymore, well, keep out this parameter and reboot your database.
If you don't tell some special format to Oracle, It's always assume the default.
Hope this help you
Christophe wrote:
> From Christophe LUCET,
> L.S.A., Paris :
>
> Hello!
>
> I need to set my date format on a database with Oracle 7.3.3.0.0. I tried
> with the command :
> ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';
> but when i want to insert a date with this format, an error occurs since the
> 'DD/MM/YY' format is needed.
> I wonder if the alter session effects end with a commit/rollback...
>
> If someone can help me, i would be very appreciative.
> My e-mail : clucet_at_perinfo.com or lsa.perinfo_at_wanadoo.fr
>
> Thanks! Hi!
>
--
"Smell the Flower While you can"