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 -> Re: How to increase the space in DATE?

Re: How to increase the space in DATE?

From: Martin Jesterhoudt <mjesterh_at_worldonline.nl>
Date: Tue, 27 Apr 1999 19:45:30 GMT
Message-ID: <37261345.5131168@news.worldonline.nl>


Hi Grace,

>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.

If you queried from a Windows client, you can also set NLS_DATE_FORMAT parameter in the registry. Maybe that's the problem/solution in your situation?


Received on Tue Apr 27 1999 - 14:45:30 CDT

Original text of this message

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