List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:December 31 2008 6:13pm
Subject:Compare DATETIME to DATE
View as plain text  
Hi,
I don't quite understand (or even know) what the "proper" way to compare a
DATETIME column to a given DATE value is. I've used various methods but I'd
like to know if there's a better way to compare these values.

Right now I have a query with this in the WHERE clause (customer.created_dt
is a DATETIME):

AND CAST(customer.created_dt AS DATE) BETWEEN '2008-12-30' AND '2008-12-30'

This was working (MySQL on Win32) before I moved the database to MySQL on
RHEL 64-bit (5.0.45-log).

Should that work?

I've also done this:

AND customer.created_dt BETWEEN '2008-12-30 00:00:00' AND '2008-12-30
23:59:59'

That works on both servers, but I really don't want to have to put the time
in there (unless that's the way you are supposed to do this).

I've though about using DATE_FORMAT... not sure about that either.


-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
Compare DATETIME to DATEJohnny Withers31 Dec
  • RE: Compare DATETIME to DATEJerry Schwartz31 Dec
  • RE: Compare DATETIME to DATEGary W. Smith31 Dec
    • Happy New YearJohn Daisley1 Jan
      • Re: Happy New YearPrathima Rao1 Jan
        • Re: Happy New YearFish Kungfu1 Jan