Display local time zone

[Michael J]

Our database date/time values are stored in GMT. However, when I perform a query, I would like the date/time results to display in CST. db version: Oracle 9.2.05

How can I make this display change??

 

[Marco Kalter]

The timestamp values are displayed in accordance with the NLS_TIMESTAMP_FORMAT and NLS_TIMESTAMP_TZ_FORMAT settings in the registry of the Primary Oracle Home.

 

[Michael J]

So could I add a procedure to pl/sql developer to convert all date/time field to local time instead of GMT whenever I query the db?