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