Skip to Content.
Sympa Menu

freetds - Re: BUG: Local Zone Timestamp - FIX

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Craig Spannring <cts AT internetcds.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: BUG: Local Zone Timestamp - FIX
  • Date: Thu, 29 Apr 1999 14:49:53 -0600 (MDT)



I'll get back to you when I have some time on this matter.

joel_trunick AT dell.com writes:
> 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
>
>
> ---
> You are currently subscribed to freetds as: cts AT internetcds.com
> To unsubscribe, forward this message to $subst('Email.Unsub')
>
--
=======================================================================
Life is short. | Craig Spannring
Bike hard, ski fast. | cts AT internetcds.com
--------------------------------+------------------------------------
Any sufficiently horrible technology is indistinguishable from Perl.
=======================================================================




Archive powered by MHonArc 2.6.24.

Top of Page