Hello
I have in a SQL an agenda table in which i have the user, the date begin and the date end of the appointment.
What i'ld like to do is to split into half an hour every hour between the date begin and the date end.
Example :
User - DateBegin - Date End
1 - 2017-04-27 09:30 - 2017-04-27 11:00
Would return
User - Date Begin - Date End - Time
1 - 2017-04-27 09:30 - 2017-04-27 11:00 - 09:30
1 - 2017-04-27 09:30 - 2017-04-27 11:00 - 10:00
1 - 2017-04-27 09:30 - 2017-04-27 11:00 - 10:30
1 - 2017-04-27 09:30 - 2017-04-27 11:00 - 11:00
Thanks for your help
Cheers
Didier