php_dave Posted August 7, 2008 Share Posted August 7, 2008 Hey guys, Say i have a start_date of 2008-08-09 12:00:00 and an end_date of 2008-08-09 14:00 and I want to pull records from a table which has Start Stamp : 2008-08-09 11:00:00 and an End Stamp of 2008-08-09 15:00:00 I cant use where Start Stamp >= start_date AND End_Stamp <= end_date - but need to pull all records that occur within start_date <> end_date Any ideas? Quote Link to comment Share on other sites More sharing options...
Xurion Posted August 7, 2008 Share Posted August 7, 2008 Look into the mysql datediff function. 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.