forumnz Posted June 7, 2008 Share Posted June 7, 2008 I have a table in a database, and I want to select all the rows with a datetime between two dates.. for example from the start of June until now.. how do I do this in a mysql query? Thanks! Sam. Link to comment https://forums.phpfreaks.com/topic/109169-selecting-between-datetime/ Share on other sites More sharing options...
mrdamien Posted June 8, 2008 Share Posted June 8, 2008 SELECT * FROM db WHERE `date` BETWEEN UNIX_TIMESTAMP('2008-06-01 00:00:00') AND UNIX_TIMESTAMP(NOW()) Link to comment https://forums.phpfreaks.com/topic/109169-selecting-between-datetime/#findComment-560125 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.