MySQL Select Date Equal to Today

Question

I m trying to run a mysql select statement where it looks at today s date and only returns results that signed up on that current day  I ve currently tried the following  but it doesn t seem to work   SELECT users id  DATE FORMAT users signup date    Y- m- d        FROM users      WHERE users signup date   CURDATE     I ve modified my SELECT statement to this  thanks guys   SELECT id FROM users WHERE DATE signup date    CURDATE

User · Answer

Sounds like you need to add the formatting to the WHERE:

SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d') 
FROM users 
WHERE DATE_FORMAT(users.signup_date, '%Y-%m-%d') = CURDATE()

See SQL Fiddle with Demo

User · Answer

This query will use index if you have it for signup date field  SELECT users id  DATE FORMAT users signup date    Y- m- d        FROM users      WHERE signup date  gt   CURDATE    amp  amp  signup date  lt   CURDATE     INTERVAL 1 DAY

User · Answer

SELECT users id  DATE FORMAT users signup date    Y- m- d    FROM users  WHERE DATE signup date    CURDATE

User · Answer

You can use the CONCAT with CURDATE   to the entire time of the day and then filter by using the BETWEEN in WHERE condition  SELECT users id  DATE FORMAT users signup date    Y- m- d    FROM users  WHERE  users signup date BETWEEN CONCAT CURDATE      00 00 00   AND CONCAT CURDATE      23 59 59

[mysql] MySQL Select Date Equal to Today

Examples related to mysql