store the date time format in YYYY-MM-DD H:I:S, so you can easily
SELECT *
FROM table_name
WHERE start_datetime BETWEEN value1 AND value2 AND end_datetime BETWEEN value1 AND value2;
3
solved Between And Greater Than Date Should Be Implement In Same Query [closed]