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 -> Setting date format in Oracle 8i

Setting date format in Oracle 8i

From: Marco Mapelli <mapellim_at_usa.net>
Date: 7 Oct 2001 09:50:10 -0700
Message-ID: <53d76e1f.0110070850.7b52c150@posting.google.com> 





Hello Tom,



I just changed my init.ora file to specify 
a desidere date format thru the parameter



NLS_DATE_FORMAT = DD-MM-YYYY


but after restarting my instance and connecting
to sqlplus and selecting from a DATE field I still
see the default date format DD-MON-YY without 
altering any session.


Should the initialization parameter set the date format
for all sessions ?



Thanks and regards



Marco
Received on Sun Oct 07 2001 - 11:50:10 CDT












Original text of this message













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