Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need to set rmy date format to 'DD/MM/YYYY'

Re: Need to set rmy date format to 'DD/MM/YYYY'

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Mon, 14 Sep 1998 19:48:08 -0700
Message-ID: <6tkk8f$1g5@dfw-ixnews8.ix.netcom.com>


Are you using Oracle for Windows client/server?

Christophe wrote in message <6tj7um$nha$1_at_platane.wanadoo.fr>...
>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!
>
>
Received on Mon Sep 14 1998 - 21:48:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US