Dates not compared properly, part II

2001-06-01 Thread Christopher P. Lindsey
-- 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] Mime-Version: 1.0 Content-Type: text/plain; charset=us

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(*) |