setting timezone at oracle database level

From: Bhupendra B Babu <bbabu_at_netscape.com>
Date: Wed, 11 Apr 2001 13:05:23 -0700
Message-ID: <3AD4B903.D9719EBC_at_netscape.com>


Is there anyway we can set up a timezone as a part of date format ,like time portion of the date ?

e.g.
set format='dd-mon-yyyy hhmiss' - here we are setting hour,minutes,seconds
same way
set format='dd-mon-yyyy hhmiss timezone' - is it possible ?

Bhupendra B Babu Received on Wed Apr 11 2001 - 22:05:23 CEST

Original text of this message