Re: How to get timezone in 9i

Thanks for your response.
I need to get international time zones in 3 letter format, something like EST,CDT ....etc.

On Fri, 18 Feb 2005 15:40:01 +0100, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
> Hi Sami
>
> >We have to store all the date/times in GMT format. Is there aeasy way
> >to get db timezone without using java program in 9i?
>
> SQL> select dbtimezone from dual;
>
> DBTIME
> ------
> +01:00
>
> HTH
> Chris

--
http://www.freelists.org/webpage/oracle-l