freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Bizarre date wraparound bug

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

Bizarre date wraparound bug, Craig Davison, 10/16/2001
- <Possible follow-up(s)>
- Re: Bizarre date wraparound bug, Craig Davison, 10/16/2001
- Re: Bizarre date wraparound bug, Craig Davison, 10/16/2001
- Re: Bizarre date wraparound bug, Michael Peppler, 10/16/2001
- Re: Bizarre date wraparound bug, Craig Davison, 10/16/2001
- Re: Bizarre date wraparound bug, Brian Bruns, 10/16/2001
- Re: Bizarre date wraparound bug, Lowden, James K, 10/17/2001
- Re: Bizarre date wraparound bug, James K. Lowden, 10/24/2001