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 -> Getting NLS_DATE_FORMAT to work with MM/DD/RR parameter

Getting NLS_DATE_FORMAT to work with MM/DD/RR parameter

From: Gerald M. Lewis <gmlewis_at_ix.netcom.com>
Date: Fri, 13 Nov 1998 16:32:17 GMT
Message-ID: <364c5d37.1058009@nntp.ix.netcom.com> 





I would like to have the database either roll-up or roll-down the
century on date columns.  From what I have read, it appears that the
NLS_DATE_FORMAT initialization parameters allows you to to this.  I
have modified the INITORCL.ORA file to include the following:



NLS_DATE_FORMAT = "MM/DD/RR"


I have tried several other combinations with no success.  Anytime I
insert a date, e.g, 11/13/02, I get 11/13/1902.  What am I doing
wrong?  Any help would be greatly appreciated.  Thanks in advance.



Gerald M. Lewis


Senior Systems Expert


HAZMED, Inc.
Received on Fri Nov 13 1998 - 10:32:17 CST












Original text of this message













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