Perad Posted September 15, 2009 Share Posted September 15, 2009 I have a date time field. How do I grab all fields where the date time field is older than one day? Link to comment https://forums.phpfreaks.com/topic/174293-solved-get-records-older-than-one-day/ Share on other sites More sharing options...
onedumbcoder Posted September 15, 2009 Share Posted September 15, 2009 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); Link to comment https://forums.phpfreaks.com/topic/174293-solved-get-records-older-than-one-day/#findComment-918778 Share on other sites More sharing options...
Perad Posted September 15, 2009 Author Share Posted September 15, 2009 Thanks a lot Link to comment https://forums.phpfreaks.com/topic/174293-solved-get-records-older-than-one-day/#findComment-918779 Share on other sites More sharing options...
onedumbcoder Posted September 15, 2009 Share Posted September 15, 2009 np, gl. Link to comment https://forums.phpfreaks.com/topic/174293-solved-get-records-older-than-one-day/#findComment-918780 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.