Re: [PHP] Selecting Dates

Hello Jordan, On 08-Apr-01 06:58:16, you wrote: >I'm trying to select records based on dates. >I have a table with dates in the format 2001-04-08 and I'm using the query: >SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001 >AND MONTH(date_time) = 04 AND DAYOFMONTH(dat

[PHP] Selecting Dates

Hi, I'm trying to select records based on dates. I have a table with dates in the format 2001-04-08 and I'm using the query: SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001 AND MONTH(date_time) = 04 AND DAYOFMONTH(date_time) = 08 But it doesn't yield any records? I