Select todays records from DateTime field

[alwoodman]

Im trying to select all the records that were created today irrespective of time from a Datetime field. This is what i have so far but it only pulls yesterdays.

 

SELECT * FROM table WHERE date_time_value < curdate() and date_time_value> DATE_ADD(CURDATE(), INTERVAL -1 day) ORDER BY date_time_value ASC

 

thanks in advance

 

Lee

[PFMaBiSmAd]

SELECT * FROM table WHERE DATE(date_time_value) = curdate() ORDER BY date_time_value