Home » RDBMS Server » Server Administration » summertime (database oracle10g, 9i, 7 - application server, all versions)
summertime [message #347916] Mon, 15 September 2008 01:23 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi All,

by next month we shall implement summertimes, ie we shall push our clock by 1 hour.

Can I know the implications on all oracle database and application server versions.



Thank you,
Dirish
Re: summertime [message #347928 is a reply to message #347916] Mon, 15 September 2008 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on the datatypes you used.
Do you use datatypes with time zone?
If not, there is no impact.

Regards
Michel
Re: summertime [message #348104 is a reply to message #347928] Mon, 15 September 2008 11:23 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
what you mean by datatypes with timezone?
Re: summertime [message #348107 is a reply to message #348104] Mon, 15 September 2008 11:34 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
He means the datatypes with timezones

For example :
Quote:

TIMESTAMP WITH TIME ZONE Datatype

The datatype TIMESTAMP WITH TIME ZONE, which extends the datatype TIMESTAMP, includes a time-zone displacement. The time-zone displacement is the difference (in hours and minutes) between local time and Coordinated Universal Time (UTC)—formerly Greenwich Mean Time. The syntax is: ....

Previous Topic: Get Default Datafile directory
Next Topic: Error when adding partitions to already partitioned table
Goto Forum:
  


Current Time: Thu Dec 08 04:16:11 CST 2016

Total time taken to generate the page: 0.08531 seconds