Skip to Content.
Sympa Menu

freetds - Re: Bizarre date wraparound bug

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Bizarre date wraparound bug
  • Date: Tue, 16 Oct 2001 15:47:19 -0700


Craig Davison writes:
> Now that I think about it, I suppose that's the lowest date on my 32-bit
> UNIXish system (-2147483648 seconds from 1970-01-01 00:00:00)
>
> Still, this is a bug.

Yeah - datetime should really be represented by two 32bit ints, where
the first one is days since jan 1 1900, and the second one is the
number of 300th of a second since midnight.

I guess FreeTDS takes a short cut and converts the data to standard
time_t format (which is OK for most things, of course).


Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com




Archive powered by MHonArc 2.6.24.

Top of Page