Re: Timezone Conversion
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:
www.psoug.org
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 http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Thu Jul 07 2005 - 17:58:57 CEST