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? Link to comment https://forums.phpfreaks.com/topic/118604-records-that-occur-within-a-time-period/ Share on other sites More sharing options...
Xurion Posted August 7, 2008 Share Posted August 7, 2008 Look into the mysql datediff function. Link to comment https://forums.phpfreaks.com/topic/118604-records-that-occur-within-a-time-period/#findComment-610689 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.