date format

[jayjabour]

I have a 9i db and set the nls_date_format in the initialization parameters to DD-MON-YYYY. when I select a field in sqlplus that has a date value it shows it in DD-MON-YY. I even set the NLS_lang registry key for oracle to DD-MON-YYYY. Why wont the date format show what I set it for?

[gandolf989]

Do a show all from sql plus to see what the client is set for.

[thomasp]

Do a

alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY';

and then run your query or
why dont you do a select like

select to_char(datefield,'DD-MON-YYYY') from table;

It doesnt make sense to change the nls_lang for this.

[jain_mk2]

there may be a problem with your sql editor
i tried it in sql plus it works fine....but when i am issuing the same in toad it is not working.....


M Jain

[davey23uk]

not working? define not working