Hello,
I have a table which contains a schedule where there for each record is a start date/time and a stop date/time in the format "YYYY-MM-DD HH:MM:SS".
How can I do a query to return the records where the current time is between start and stop? I've been trying this with various variations, but unsuccessfully:
$sql="SELECT * FROM tblschedule WHERE (NOW() BETWEEN Start AND Stop)";
I've also tried using current_timestamp and a PHP variable $today = date("Y-m-d H:i:s");
Guidance very much appraciated,
Bernhard S.
