TheBrandon Posted June 8, 2012 Share Posted June 8, 2012 Hello all, I need to pull all of the records in MySQL since a certain date. I have my dates stored in MySQL in SQL's timestamp format. I thought a query like: SELECT * FROM orders WHERE orders_date_purchased > "2011-04-19 00:00:00" Would do it but so far it's not. That is returning "2012-04-17 14:26:35" which should be outside of the range I want. If I change the direction to: SELECT * FROM orders WHERE orders_date_purchased > "2011-04-19 00:00:00" The only thing it returns is 0000-00-00 00:00:00. This seems horribly simple and maybe the coffee just hasn't kicked in yet but I can't figure it out. Anyone have any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/263866-help-comparing-dates-through-mysql/ Share on other sites More sharing options...
Pikachu2000 Posted June 8, 2012 Share Posted June 8, 2012 Those queries are the same. Copy and paste the actual query strings in here. Quote Link to comment https://forums.phpfreaks.com/topic/263866-help-comparing-dates-through-mysql/#findComment-1352185 Share on other sites More sharing options...
TheBrandon Posted June 8, 2012 Author Share Posted June 8, 2012 Those queries are the same. Copy and paste the actual query strings in here. I'm sorry, the second one was changed to: SELECT * FROM orders WHERE orders_date_purchased < "2011-04-19 00:00:00" Quote Link to comment https://forums.phpfreaks.com/topic/263866-help-comparing-dates-through-mysql/#findComment-1352188 Share on other sites More sharing options...
PFMaBiSmAd Posted June 8, 2012 Share Posted June 8, 2012 "2012-04-17 14:26:35" which should be outside of the range I want. 2012-04-17 14:26:35 is greater than "2011-04-19 00:00:00" Quote Link to comment https://forums.phpfreaks.com/topic/263866-help-comparing-dates-through-mysql/#findComment-1352193 Share on other sites More sharing options...
TheBrandon Posted June 8, 2012 Author Share Posted June 8, 2012 "2012-04-17 14:26:35" which should be outside of the range I want. 2012-04-17 14:26:35 is greater than "2011-04-19 00:00:00" Yep. I'm retarded. That's what the issue was. Thank you. Got it working. Quote Link to comment https://forums.phpfreaks.com/topic/263866-help-comparing-dates-through-mysql/#findComment-1352194 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.