Date format not working

[JACK343]

Version 8.0.3.1510

To display date in the format of 18-OCT-2010 02:57:05 PM

On Tools> preferences > NLS Options
i selected 'User-defined' and entered DD-MON-YYY

But, the date is coming up as

18-10O57-2010 02:57:05 PM
instead of 18-OCT-2010 02:57:05 PM

So, i executed ALTER SESSION (after restart)
alter session set nls_Date_Format = 'DD-MON-YYY'

But the date still comes up as

18-10O57-2010 02:57:05 PM

for a query like

select sysdate from dual

 

[Marco Kalter]

You will need to use the Windows date format system. So instead of DD-MON-YYYY you would need to specify dd-MMM-yyyy.

 

[JACK343]

Thank you Marco