[SOLVED] Get records older than one day?

[Perad]

I have a date time field. How do I grab all fields where the date time field is older than one day?

[onedumbcoder]

I am working on a game from my younger 9 yr old brother and I had to come up with some sort of equation like that and it turned out is was really easy, here is what I used:

 

SELECT (number_of_jews_killed + number_of_arabirans_killed) AS level_of_greatness FROM hitler_kills WHERE date_stamp < DATE_ADD(NOW(), INTERVAL -1 DAY);

 

[Perad]

Thanks a lot

[onedumbcoder]

np, gl.