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

Home -> Community -> Usenet -> c.d.o.misc -> How to increase the space in DATE?

How to increase the space in DATE?

From: Grace Tsai <gtsai_at_bnl.gov>
Date: Tue, 27 Apr 1999 13:08:12 -0400
Message-ID: <3725EEFC.C8B6E2E2@bnl.gov> 





I like to change the format of DATE. The default one is "DD-MON-YY"
(e.g., today is 27-APR-99). I like to change it to "DD-MON-YYYY".
In file init<SID>.ora, I added the line



NLS_DATE_FORMAT = "DD-MM-YYYY"


then, I restarted the instance.



I got the output 27-APR-19. It seems the default space to display a DATE
variable


is only 9 digits. Does anybody know how to increase the space? Thanks in
advance.



Grace Tsai


Brookhaven National Lab

Received on Tue Apr 27 1999 - 12:08:12 CDT












Original text of this message













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