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? Quote 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); Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.