Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to increase the space in DATE?
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?
![]() |
![]() |