lundi 25 juillet 2016

Remove multiple time intervals in mysql

I'm using the command below to remove time intervals like time between 9:25 am and 9:35 am but its not working.

WHERE TIMEONLY NOT IN ((TIMEONLY BETWEEN '09:25:00' AND '09:35:00') OR (TIMEONLY BETWEEN '11:55:00' AND '12:05:00') OR (TIMEONLY BETWEEN '15:10:00' AND '15:20:00'))

Any suggestions! I highly appreciate your help.

Rishabh

Aucun commentaire:

Enregistrer un commentaire