Hello to all,
from a table made like this :
ID | StartDate | EndDate | Ora_inizio | Ora_fine |
a | 02/03/2018 09:59:23 | 02/03/2018 10:04:53 | 09:59 | 10:04 |
b | 02/03/2018 09:02:23 | 02/03/2018 09:03:53 | 09:02 | 09:03 |
c | 02/03/2018 09:03:13 | 02/03/2018 09:05:43 | 09:03 | 09:05 |
I would like to have a table like that:
ID | StartDate | EndDate | Ora_inizio | Ora_fine |
a | 02/03/2018 09:59:23 | 02/03/2018 10:04:53 | 09:59 | 10:04 |
a | 02/03/2018 09:59:23 | 02/03/2018 10:04:53 | 10:00 | 10:04 |
a | 02/03/2018 09:59:23 | 02/03/2018 10:04:53 | 10:01 | 10:04 |
a | 02/03/2018 09:59:23 | 02/03/2018 10:04:53 | 10:02 | 10:04 |
a | 02/03/2018 09:59:23 | 02/03/2018 10:04:53 | 10:03 | 10:04 |
a | 02/03/2018 09:59:23 | 02/03/2018 10:04:53 | 10:04 | 10:04 |
b | 02/03/2018 09:02:23 | 02/03/2018 09:03:53 | 09:02 | 09:03 |
b | 02/03/2018 09:02:23 | 02/03/2018 09:03:53 | 09:03 | 09:03 |
c | 02/03/2018 09:03:13 | 02/03/2018 09:05:43 | 09:03 | 09:05 |
c | 02/03/2018 09:03:13 | 02/03/2018 09:05:43 | 09:04 | 09:05 |
c | 02/03/2018 09:03:13 | 02/03/2018 09:05:43 | 09:05 | 09:05 |
Someone could help me.
Thanks in advance