Re: How to increase the space in DATE?

From: <smotwani_at_my-dejanews.com>
Date: Tue, 27 Apr 1999 18:48:33 GMT
Message-ID: <7g50q0$8q1$1@nnrp1.dejanews.com>

I had the same problem before. I did the following : Remove the Quotes and just specify:

NLS_DATE_FORMAT=DD-MM-YYYY. This will work fine now if you run SQL*Plus from the server where the database is. If you are running the script from the client or Application Server, make sure that the ORACLE.INI also has the same NLS_DATE_FORMAT set under the [Oracle] section of the file. Inform me when it works.

Thanks,
Sushil Motwani

In article <3725EEFC.C8B6E2E2_at_bnl.gov>, Grace Tsai <gtsai_at_bnl.gov> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 27 1999 - 13:48:33 CDT