Thread: Datum vergleich mit MYSQL

 
SELECT * FROM #__controler WHERE `id` = 1 AND (starttime < NOW() AND endtime > NOW()) OR (starttime < NOW() AND endtime = NULL) OR (starttime = NULL AND endtime > NOW())

SELECT * FROM #__controler WHERE `id` = 1 AND ( NOW() BETWEEN starttime AND endtime ) OR (starttime < NOW() AND endtime = NULL) || (starttime = '0000-00-00 00:00:00' && endtime > NOW())

SELECT * FROM #__controler WHERE `id` = 1 AND (starttime < NOW() AND endtime > NOW()) OR (starttime < NOW() AND endtime = '0000-00-00 00:00:00') OR (starttime = '0000-00-00 00:00:00' AND endtime > NOW())

SELECT * FROM ... WHERE id = 1 AND ( <datumsausdruck> )

 
 SELECT *
FROM wieschoo_controler
WHERE `id` =1
AND (
(
starttime < NOW( )
AND endtime > NOW( )
)
OR (
(
starttime < NOW( )
)
AND (
endtime = '0000-00-00 00:00:00'
)
)
OR (
(
starttime = '0000-00-00 00:00:00'
)
AND (
endtime > NOW( )
)
)
)
LIMIT 0 , 30