RE: Oracle - DST 2007 heads up



-----Original Message-----
From: DaveG [mailto:david.gudewicz@xxxxxxxxxx]
Sent: February 14, 2007 2:51 PM
To: Info-VAX@xxxxxxxxxxxx
Subject: Oracle - DST 2007 heads up

Learned this yesterday.

Oracle introduced the data types TSLTZ (timestamp with local time
zone) and TSTZ (timestamp with timezone) with 9i. If you have Oracle
apps that utilize the above data types, Oracle needs to be patched to
comply with the new 2007 DST rules if you live in an area where those
rules apply.

This is in addition to the OpenVMS and Java patches that may be
required, depending on version caveats.


Dave...



In addition to the above, some additional links of interest:

http://blogs.oracle.com/schan/2007/01/19 - Oracle eBusiness suite and
DST

http://www.hp.com/go/dst - HP

http://support.microsoft.com/gp/cp_dst - Microsoft

http://www.ibm.com/support/alerts/us/en/daylightsavingstimealert.html -
IBM

http://inms-ienm.nrc-cnrc.gc.ca/time_services/daylight_saving_e.html -
Canada time zones and DST

http://java.sun.com/developer/technicalArticles/Intl/USDST/ - Sun

http://wwp.greenwichmeantime.com/daylight-saving-time/usa/dst-2007.htm -
Interesting background info


Regards

Kerry Main
Senior Consultant
HP Services Canada
Voice: 613-592-4660
Fax: 613-591-4477
kerryDOTmainAThpDOTcom
(remove the DOT's and AT)

OpenVMS - the secure, multi-site OS that just works.

.

Relevant Pages

  • Re: Number of days since 1/1/2000
    ... with DST without using any module. ... local time zone, and not some specific zone such as UTC? ... claiming that "most applications" ignore the daylight savings issue? ...
    (comp.lang.perl.misc)
  • Re: Number of days since 1/1/2000
    ... smallpond wrote: ... with DST without using any module. ... local time zone, and not some specific zone such as UTC? ...
    (comp.lang.perl.misc)
  • Re: daylight savings time mystery
    ... DateTime is time zone aware because it says in that document that ... use the local time zone when making calculations ... So if the local time zone uses DST then noon on May 1 is one hour ...
    (microsoft.public.dotnet.languages.csharp)
  • Oracle and Dates
    ... I say this about Oracle and dates in the Java glossary. ... hand experience. ... when you retrieve them they automatically convert to local time. ... Store dates as longs or ints to avoid ...
    (comp.lang.java.databases)
  • Oracle in non-global zone
    ... I hoped that the zone oracle would automatically benefit from these ... When installing in a non-global zone one instead has to add the ... if I wantto install Oracle in the global zone? ...
    (SunManagers)