freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: JDBC: Problem with DSTOffset in binding date-values

From: Stefan Bodewig <bodewig AT bost.de>
To: <freetds AT franklin.oit.unc.edu>
Subject: Re: JDBC: Problem with DSTOffset in binding date-values
Date: 09 Nov 2000 18:15:04 +0100

Andreas Schörk <andreas.schoerk AT infor.de> wrote:

> To show the differences you have to be in an area where daylight
> saving is done during August 2007. For instance GMT + 1.

Thats mine!!! ;-)

OK, I've run your tests and got

got 2007-09-09 13:35:06.4, expected 2007-09-09 15:35:06.4
got 1998-03-09 15:35:05.4, expected 2007-09-09 15:35:06.4
got 2007-09-09 13:35:00.0, expected 2007-09-09 15:35:00.0
got 1998-03-09 15:35:00.0, expected 2007-09-09 15:35:00.0

but they already hold these values in the DB, i.e. when I query them
using QueryAnalyzer. So it cannot be the part that is retrieving the
data, or am I missing something?

Stefan

JDBC: Problem with DSTOffset in binding date-values, Schörk, Andreas, 11/09/2000
- <Possible follow-up(s)>
- Re: JDBC: Problem with DSTOffset in binding date-values, Bob Kline, 11/09/2000
- Re: JDBC: Problem with DSTOffset in binding date-values, Schörk, Andreas, 11/09/2000
- Re: JDBC: Problem with DSTOffset in binding date-values, Stefan Bodewig, 11/09/2000
- Re: JDBC: Problem with DSTOffset in binding date-values, Bob Kline, 11/09/2000