Daylight Savings Time Problems

Article View: borland.public.interbase.sql

Article #1025

Back to borland.public.interbase.sql Previous Next

#1025

From: rame100
Date: Wed, 14 Mar 2007 23:55

16 lines
1807 bytes

All SQL queries that use 'NOW' to generate a TIMESTAMP are reporting
one hour earlier than they should as if Daylight Saving Time hasn't
occurred.  This behavior started this last weekend with the DST time
shift. The Server on which IB is running shows the correct time on its
corner digital clock.  It reports the correct Time Zone as Pacific
Time and that it has activated Daylight Saving Time.

I have IB 7.5.1.80 running on a Windows 2000 Server SP4.

Borland reports on their web site that they expect no problems with
the DST and that they get the time for NOW calculations from the
server's internal clock.

However, my server is reporting the correct time but IB is not.

Is anyone else experiencing this?

Technical Details

Message-ID: <1173916541.073334.81070@l77g2000hsb.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!l77g2000hsb.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,c963cacfcda586fc,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!l77g2000hsb.googlegroups.com!not-for-mail
From: rame100@gmail.com
Newsgroups: borland.public.interbase.sql
Subject: Daylight Savings Time Problems
Date: 14 Mar 2007 16:55:41 -0700
Organization: http://groups.google.com
Lines: 17
Message-ID: <1173916541.073334.81070@l77g2000hsb.googlegroups.com>
NNTP-Posting-Host: 63.105.29.67
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1173916542 9380 127.0.0.1 (14 Mar 2007 23:55:42 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 14 Mar 2007 23:55:42 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: l77g2000hsb.googlegroups.com; posting-host=63.105.29.67;
   posting-account=XCMbowwAAAA5d7GNFYHGZtS068EvQRWI