Re: Timezone Conversion

From: DA Morgan <>
Date: Thu, 07 Jul 2005 08:58:57 -0700
Message-ID: <1120751966.175329_at_yasure>

Miggins wrote:
> Hi,
> Has anyone got experience of converting a system to allow it to cater
> for Timezone support. What are the pitfalls, problems etc.
> Am running 9.2 with Forms and Reports 6i through 9ias.
> There will obviously be data migration and changes to the DATE
> datatypes and I assume all instances of to_date and to_char will need
> visiting.
> Any hints, tips, tales of woe greatly appreciated.
> Cheers

Examples of using the TIMESTAMP WITH TIMEZONE can be found at:
click on Morgan's Library
click on Time Zones

They are easy to use but your issue is not with the database but rather with Forms and Reports. 6i is quite old and may not provide the support forcing you to do all calculations in the database and just return the result set to the front-end: Not a huge price to pay.

Daniel A. Morgan
(replace x with u to respond)
Received on Thu Jul 07 2005 - 17:58:57 CEST

Original text of this message