jasonc Posted September 19, 2009 Share Posted September 19, 2009 return entiries only if the value of the field is more than '"2009-08-19" i have messed up big time and used the datetime and not the time so all data is stored in GMT and not the unix time stamp format 123456568 there is no chance to change this now so need to be able to return all results that have the GMT data more than today less one month, the last months entries. how can i correctly do this please. Link to comment https://forums.phpfreaks.com/topic/174786-return-entiries-only-if-the-value-of-the-field-is-more-than-2009-08-19/ Share on other sites More sharing options...
gassaz Posted September 21, 2009 Share Posted September 21, 2009 Try this... Select * from Tablename where date_field >= '2009-08-19' and date_field<='2009-09-19' Link to comment https://forums.phpfreaks.com/topic/174786-return-entiries-only-if-the-value-of-the-field-is-more-than-2009-08-19/#findComment-922412 Share on other sites More sharing options...
fenway Posted October 2, 2009 Share Posted October 2, 2009 You're storing your dates how? Link to comment https://forums.phpfreaks.com/topic/174786-return-entiries-only-if-the-value-of-the-field-is-more-than-2009-08-19/#findComment-929124 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.