FreeTDS Development Group

[joel_trunick AT dell.com]

Greg,

I didn't seem to get a response to the following posts.  Could you make a 
comment as to the appopriateness of these posts?

Thanks,
Joel


-----------------------------------------------------
Here is the fix for correcting the Java client from converting timestamps 
to GMT.  Could this be added to the FreeTDS driver?

Thanks,
Joel Trunick
Dell Computer

GregorianCalendar cal = new GregorianCalendar();
int offset = cal.get(Calendar.ZONE_OFFSET) + cal.get(Calendar.DST_OFFSET);

ts = new Timestamp( ts.getTime() - offset );

----------------------------------------------------
I noticed the JDBC 2.0 specification allows you do a 
TimeZone.setDefault("your time zone") and you can expect getTimestamp to 
return an appropriate Date/Timestamp.

Specs are at 
http://java.sun.com/products/jdk/1.2/docs/guide/jdbc/index.html

Joel