dc_jt Posted May 1, 2009 Share Posted May 1, 2009 Whats the best way to check two dates against a date in a mysql format. I.e I have many dates in this format 0000-00-00 00:00:00 I then pick two dates e.g 20/04/2009 and 2/05/2009. I want to find all dates between these two dates. What is the best way to do this? I presume I need to change the format, do I change them into the same format as the first date (0000-00-00 00:00:00 ) or do I change them all into another format i.e using strtotime/timestamp? Thanks Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted May 1, 2009 Share Posted May 1, 2009 http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date Quote Link to comment 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.