Home » RDBMS Server » Server Administration » Upgrading from PST to GMT (Oracle 10.2.0.2, Solaris 9)
Upgrading from PST to GMT [message #425131] Wed, 07 October 2009 12:31 Go to next message
dasuwal@gmail.com
Messages: 20
Registered: June 2009
Junior Member
Hi Forum

While upgrading to 11g, we are moving to new servers with GMT timezones. The current timezone is PDT on OS level.

Please let me know if the database (date & timestamp columns)
can be converted to GMT from PST while upgrading.

Thanks in advance.

Report message to a moderator

Re: Upgrading from PST to GMT [message #425132 is a reply to message #425131] Wed, 07 October 2009 12:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please let me know if the database (date & timestamp columns can be converted to GMT from PST while upgrading.

DATE datatype does not contain TZ reference.

Which datatype(s) are you concerned about?
Exactly what would you like to occur?

Report message to a moderator

Re: Upgrading from PST to GMT [message #425139 is a reply to message #425131] Wed, 07 October 2009 13:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ALTER DATABASE SET TIME_ZONE
But this can't be done if there is any TIMESTAMP WITH LOCAL TIME ZONE data in your database.

Regards
Michel

Report message to a moderator

Re: Upgrading from PST to GMT [message #425329 is a reply to message #425131] Thu, 08 October 2009 11:29 Go to previous messageGo to next message
dasuwal@gmail.com
Messages: 20
Registered: June 2009
Junior Member
A few tables in database consist of columns with Date datatype. We are moving DB and applications to GMT servers from PST timezone. My applications run depending on those Date columns for eg:

A table t1 with column Input_time has 8:00 pm in date column. An application will run when the application time matches this column.
Since we have moved to new timezone, the application time will be different ( as it pick time from OS) causing the lag and latency.

My concern is whether we can convert this date datatype to auto adjust with new OS timezone.

Thanks a lot for your feedbacks.

Report message to a moderator

Re: Upgrading from PST to GMT [message #425333 is a reply to message #425329] Thu, 08 October 2009 11:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
My concern is whether we can convert this date datatype to auto adjust with new OS timezone.

If you use a type without time zone (like DATE), the input date is stored like you entered it. Time zone is then irrelevant with this type.

Regards
Michel

Report message to a moderator

Re: Upgrading from PST to GMT [message #425335 is a reply to message #425329] Thu, 08 October 2009 11:43 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>We are moving DB and applications to GMT servers from PST timezone.
In theory, nothing prevents you from setting the system time to PST.

Given enough downtime & resources, you could run UPDATE against every row in every DATE column.

Report message to a moderator

Previous Topic: Oracle 11g/R12 database applying patch
Next Topic: ASM 11g - kernel modules
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 12:24:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.