Re: How to get timezone in 9i
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- Date: Fri, 18 Feb 2005 10:09:07 -0500
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@xxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
