Skip to Content.
Sympa Menu

freetds - Re: t0056.java a refined t0001.java

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Stefan Bodewig <bodewig AT bost.de>
  • To: <freetds AT franklin.oit.unc.edu>
  • Subject: Re: t0056.java a refined t0001.java
  • Date: 10 Nov 2000 17:29:30 +0100


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




Archive powered by MHonArc 2.6.24.

Top of Page