NLS Options

[Athlantis]

Couldn't find anything at forum so writing...

Oracle date format doesn't change through alter session adjustments. Seems an application takes it once on load from nls_database_parameters and that's all. Also manual edit in grid calendar submits wrong year: years XX00-XX68 transfer 2000-2068 and XX69-XX99 do 1969-1999 whatever it could be 1812 or 1799.
Database nls_date_format in that case was 'DD-MON-YY', possible impact.

Found both in 12, 13 versions
----------------------

select to_date('29.02.1500', 'DD.MM.YYYY') from dual;
00-h:mm:ss-00

 

[Marco Kalter]

The date format in the PL/SQL Developer user interface is controlled by the User Interface / NLS Options preferences. This is indeed a static preference that does not change when you execute an "alter session" statement.

Note that the preference uses the Windows date format syntax.

 

[Athlantis]

Interested only in Oracle date format in preferences. May we expect in future the Developer would react on alter session adjustments? It is not urgent or crucial but apparently a malfunction. For example, timestamp values change according to any nls_timestamp_format changes through a session lifetime. And it is shown in a grid fine.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

Note that for the SQL Window you can enable the "Date fields to_char" option (Preferences > Windows > SQL Window). Now the dates will be converted to a character representation on the server, using the current Oracle session format.

 

[Athlantis]

Ok, thank you very much

Anticipating