Two times between in two columns sql

Question

I have record of fromtime and endtime in database table. There is fromtime= 09:00 and endtime = 10:00 so add a new fromtime= 09:05 and endtime= 10:05 then system will b show alert message that both times already exists.

I am using this sql statement

SELECT * 
FROM `tbl_timetable` 
WHERE fromtime <= '09:05' AND totime >= '10:05'

but cannot get any alert message of both times already exists.

Table image

Well, you're asking for a record where `totime` is greater than or equal to `10:05`, and `10:00` obviously does not match that criterion. — user247702, Oct 10 '18 at 09:31
yup does not match but is there any query condition which match between 09:00 and 10:00 — Ahil Khan, Oct 10 '18 at 09:34
I guess you want to find overlapping time ranges? If so, see https://stackoverflow.com/questions/6571538/checking-a-table-for-time-overlap — user247702, Oct 10 '18 at 09:35
@sagi but user want to add this fromtime=09:05 and endtime= 10:05 then how to stop the user to add — Ahil Khan, Oct 10 '18 at 09:39

Salman A · Accepted Answer · 2018-10-10T09:52:06.590

2

Your query should be:

SELECT * 
FROM tbl_timetable
WHERE '10:05' > fromtime AND totime > '09:05'

Tests on DB Fiddle

edited Oct 10 '18 at 09:52

answered Oct 10 '18 at 09:42

Salman A

262,204
82
430
521

Two times between in two columns sql

1 Answers1