corkg Posted May 26, 2008 Share Posted May 26, 2008 Hi How do you select dates between 2 ranges i.e. 21/05/2008 - 05/06/2008 from a database when date is the name of the column? thanks Link to comment https://forums.phpfreaks.com/topic/107292-solved-select-dates-between-ranges/ Share on other sites More sharing options...
corkg Posted May 26, 2008 Author Share Posted May 26, 2008 So it would output: 21/05/2008 22/05/2008 23/05/2008 24/05/2008 25/05/2008 26/05/2008 27/05/2008 28/05/2008 29/05/2008 30/05/2008 31/05/2008 01/06/2008 02/06/2008 03/06/2008 04/06/2008 05/06/2008 Link to comment https://forums.phpfreaks.com/topic/107292-solved-select-dates-between-ranges/#findComment-550125 Share on other sites More sharing options...
corkg Posted May 26, 2008 Author Share Posted May 26, 2008 done by reversing the ddmmyyyy format to yyyymmdd Link to comment https://forums.phpfreaks.com/topic/107292-solved-select-dates-between-ranges/#findComment-550146 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.