Dates not compared properly, part II

2001-06-01 Thread Christopher P. Lindsey
Chris -- Forwarded message: > From [EMAIL PROTECTED] Tue May 1 14:37:53 2001 > Date: Tue, 1 May 2001 14:37:53 -0500 > From: "Christopher P. Lindsey" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Dates not compared properly? > Message-ID: <[EMAIL PROTECTED]> &

Dates not compared properly?

2001-05-01 Thread Christopher P. Lindsey
Howdy all... I've run into a strange date problem as of midnight, May 1, 2001 on my i686 Linux machine running mySQL 3.23.37. For some reason, queries can no longer compare dates properly: mysql> select count(*) from hit where date > NOW()-1135560; +--+ | count(*) | +---