-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Wednesday, December 31, 2008 1:13 PM
To: MySQL General List
Subject: Compare DATETIME to DATE
Hi,
I don't quite understand (or even know) what the proper way to compare
a
DATETIME column to a given DATE value
Truncate the time part of the datetime field when doing the compare
AND DATE_FORMAT(customer.created_dt, '%Y-%m-%d 00:00:00') BETWEEN '2008-12-30'
AND '2008-12-30'
Should work. Probably not the most efficient. The other options would be to
use take end date + 1 day, minue 1 second. That's