Re: Convert GMT date to Local Europe/Rome

From: SP <dario.zandolin_at_gmail.com>
Date: 22 Jun 2006 14:00:12 -0700
Message-ID: <1151010012.784074.4680@y41g2000cwy.googlegroups.com>

What you mean with "Use the built-in timezone capability "? What "timezone capability "?

Can you explain to me these functions?

Thanks.

DA Morgan ha scritto:

> SP wrote:
> > I've a db oracle with a table with a column date type.
> > The rows are write using GMT timezone.
> > I need to extract the date with Europe/Rome timezone.
> > How to convert it?
> > I try with NEW_TIME , but I can't use timezone for Europe/Rome .
> > In this timezone in summer there are +2.00, while in winter are +1.00.
> >
> > Some ideas?
>
> Use the built-in timezone capability and set up a job (DBMS_SCHEDULER
> or DBMS_JOB) to make the appropriate adjustment as required.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Thu Jun 22 2006 - 16:00:12 CDT