comparing Date Times

[axiom007]

in my database, I am storing last modified values in "Y-m-d h:i:s".  using this value, I want to see all modifications that have occured within the las 24 hours.

 

I am assuming something like:

SELECT * FROM sometable WHERE last_modified >= ????

 

any help would be appreciated.

 

I am using MySQL v 5.0.4

[corbin]

Never store date values as strings.  It's terribly slow.

 

 

Use datetime, or use an integer timestamp.

[PFMaBiSmAd]

Using a DATETIME data type, there would be several ways using mysql datetime functions -  http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

 

One possible method -

SELECT * FROM sometable WHERE last_modified >= DATE_SUB(CURDATE(),INTERVAL 24 HOUR)