SP wrote:
> 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
>
- Please do not top post.
- Go to Morgan's Library at www.psoug.org look up TIMESTAMP.
--
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 Fri Jun 23 2006 - 11:29:58 CDT
