From: "Van Messner" Newsgroups: comp.databases.oracle.server References: <3A4F6EED.5EB16FD3@0800-einwahl.de> <20001231203652.27562.00000146@ng-me1.aol.com> Subject: Re: dealing with time across national boundaries Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Tue, 02 Jan 2001 02:05:05 GMT NNTP-Posting-Host: 216.179.16.62 X-Complaints-To: Abuse Role , We Care X-Trace: monger.newsread.com 978401105 216.179.16.62 (Mon, 01 Jan 2001 21:05:05 EST) NNTP-Posting-Date: Mon, 01 Jan 2001 21:05:05 EST Organization: BestWeb (bestweb.net) While the server can always find GMT, how do you know what offset to apply for, say, Singapore at any particular day and time. How do you keep track of the offsets from GMT for every place on every day given the mess with daylight savings and local control of time? For example, I was told that SAP actually suggests shutting down your server when moving off daylight savings time! Van "Noodles" wrote in message news:20001231203652.27562.00000146@ng-me1.aol.com... > One solution we've had success with is to have local timestamps from Oracle and > also a timestamp in GMT time. The GMT time is crucial in trackng down data > transfer problems between instances spread out over 9 time zones. > > My 2 cents, > Cliff