Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Convert GMT date to Local Europe/Rome
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.orgReceived on Thu Jun 22 2006 - 12:37:48 CDT