FreeTDS Development Group

[Stefan Bodewig <bodewig AT bost.de>]

Results on my machine (GMT+1 when not in DST as well):

Starting test t0057-  Insert and retrieve timestamps
Creating table affected 0 rows
GMT+01:00
Sun Sep 09 15:35:00 GMT+02:00 2007
09.09.2007 15:35:00
Added 1 rows
Result set-
   got 2007-09-09 13:35:05.4, expected 2007-09-09 15:35:05.4 equal: false
   got 2007-09-09 15:35:05.4, expected 2007-09-09 15:35:05.4 equal: true
   got 2007-09-09 13:35:00.0, expected 2007-09-09 15:35:00.0 equal: false
   got 2007-09-09 15:35:00.0, expected 2007-09-09 15:35:00.0 equal: true
GMT+01:00
Sun Dec 09 15:35:00 GMT+01:00 2007
09.12.2007 15:35:00
Added 1 rows
Result set-
   got 2007-12-09 15:35:05.4, expected 2007-12-09 15:35:05.4 equal: true
   got 2007-12-09 15:35:05.4, expected 2007-12-09 15:35:05.4 equal: true
   got 2007-12-09 15:35:00.0, expected 2007-12-09 15:35:00.0 equal: true
   got 2007-12-09 15:35:00.0, expected 2007-12-09 15:35:00.0 equal: true
GMT+01:00
Fri Dec 09 15:35:00 GMT+01:00 2050
09.12.2050 15:35:00
Added 1 rows
Result set-
   got 1914-11-03 09:06:49.4, expected 2050-12-09 15:35:05.4 equal: false
   got 1914-11-03 09:06:49.4, expected 2050-12-09 15:35:05.4 equal: false
   got 1914-11-03 09:06:44.0, expected 2050-12-09 15:35:00.0 equal: false
   got 1914-11-03 09:06:44.0, expected 2050-12-09 15:35:00.0 equal: false
Pacific Standard Time
Sun Sep 09 15:35:00 PDT 2007
Sep 9, 2007 3:35:00 PM
Added 1 rows
Result set-
   got 2007-09-09 13:35:05.4, expected 2007-09-09 15:35:05.4 equal: false
   got 2007-09-09 15:35:05.4, expected 2007-09-09 15:35:05.4 equal: true
   got 2007-09-09 13:35:00.0, expected 2007-09-09 15:35:00.0 equal: false
   got 2007-09-09 15:35:00.0, expected 2007-09-09 15:35:00.0 equal: true
Pacific Standard Time
Sun Dec 09 15:35:00 PST 2007
Dec 9, 2007 3:35:00 PM
Added 1 rows
Result set-
   got 2007-12-09 15:35:05.4, expected 2007-12-09 15:35:05.4 equal: true
   got 2007-12-09 15:35:05.4, expected 2007-12-09 15:35:05.4 equal: true
   got 2007-12-09 15:35:00.0, expected 2007-12-09 15:35:00.0 equal: true
   got 2007-12-09 15:35:00.0, expected 2007-12-09 15:35:00.0 equal: true
Pacific Standard Time
Fri Dec 09 15:35:00 PST 2050
Dec 9, 2050 3:35:00 PM
Added 1 rows
Result set-
   got 1914-11-03 09:06:49.4, expected 2050-12-09 15:35:05.4 equal: false
   got 1914-11-03 09:06:49.4, expected 2050-12-09 15:35:05.4 equal: false
   got 1914-11-03 09:06:44.0, expected 2050-12-09 15:35:00.0 equal: false
   got 1914-11-03 09:06:44.0, expected 2050-12-09 15:35:00.0 equal: false
GMT+02:00
Sun Sep 09 15:35:00 GMT+02:00 2007
09.09.2007 15:35:00
Added 1 rows
Result set-
   got 2007-09-09 15:35:05.4, expected 2007-09-09 15:35:05.4 equal: true
   got 2007-09-09 15:35:05.4, expected 2007-09-09 15:35:05.4 equal: true
   got 2007-09-09 15:35:00.0, expected 2007-09-09 15:35:00.0 equal: true
   got 2007-09-09 15:35:00.0, expected 2007-09-09 15:35:00.0 equal: true
GMT+02:00
Sun Dec 09 15:35:00 GMT+02:00 2007
09.12.2007 15:35:00
Added 1 rows
Result set-
   got 2007-12-09 15:35:05.4, expected 2007-12-09 15:35:05.4 equal: true
   got 2007-12-09 15:35:05.4, expected 2007-12-09 15:35:05.4 equal: true
   got 2007-12-09 15:35:00.0, expected 2007-12-09 15:35:00.0 equal: true
   got 2007-12-09 15:35:00.0, expected 2007-12-09 15:35:00.0 equal: true
GMT+02:00
Fri Dec 09 15:35:00 GMT+02:00 2050
09.12.2050 15:35:00
Added 1 rows
Result set-
   got 1914-11-03 09:06:49.4, expected 2050-12-09 15:35:05.4 equal: false
   got 1914-11-03 09:06:49.4, expected 2050-12-09 15:35:05.4 equal: false
   got 1914-11-03 09:06:44.0, expected 2050-12-09 15:35:00.0 equal: false
   got 1914-11-03 09:06:44.0, expected 2050-12-09 15:35:00.0 equal: false

Passed t0057.

I've changed the line printing the TimeZone to read
getTimeZone().getDisplayName() as TimeZone obviously doesn't have a
useful toString method.

The results are the same with JDK 1.3 from IBM as well as Sun, JDK
1.2.2 and JDK 1.1.8 both Blackdown. This is Linux speaking.

Run without Bob's patch from August.

Stefan