Divide 24 hours into 3 shifts schedule with MySQL date_format function
I'm currently developing an application for shifting schedule in our team and I would like to share with you guys on how to divide 24 hours into 3 shifts. The following schedules are: First shift: 7-15 (7am-3pm) Second shift: 15-23 (3pm-11pm) Third shift: 23-7 (11pm-7am) I used date_format function in MySQL and call the current system time, and I also declare variable for each shifts in and out