format of timestamp column in SQL Window

[ap78rus]

How to set it? When I change Tools->Preferences->NLS Options it affects only displaying columns of type DATE, not TIMESTAMP.

Setting environment variable NLS_DATE_FORMAT also has no effect.

I am using PLSQL Developer 10.0.5.1710, windows 8.1 and instant client 11.2

Thank you for your time!

 

[Marco Kalter]

Timestamps are formatted by Oracle. You can change the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT registry keys of your Primary Oracle Home to control the format.

 

[ap78rus]

instant client have nothing in registry

 

[IvanZ]

Use environment variables

 

[ap78rus]

no effect from environment vars.
Only alter session/alter system have effect. And this is painful.

Does oracle really format timestamps itself? And pass it to a client as string?!

 

[marek]

you can place 'alter session set ..' statements into afterConnect.sql file

 

[ap78rus]

oh, good advice, thank you Marek!