OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » summertime (database oracle10g, 9i, 7 - application server, all versions)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

summertime [message #347916]

Mon, 15 September 2008 01:23

dirish
Messages: 232
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

Report message to a moderator

Re: summertime [message #347928 is a reply to message #347916]

Mon, 15 September 2008 01:54

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: summertime [message #348104 is a reply to message #347928]

Mon, 15 September 2008 11:23

dirish
Messages: 232
Registered: November 2006

Senior Member

what you mean by datatypes with timezone?

Report message to a moderator

Re: summertime [message #348107 is a reply to message #348104]

Mon, 15 September 2008 11:34

ThomasG
Messages: 3212
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: ....

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 15:09:35 CST 2025