Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
galileumax
Contributor II
Contributor II

Add rows in table between start and enddate for every minute

Hello to all,

from a table made like this :

     

IDStartDateEndDateOra_inizioOra_fine
a02/03/2018 09:59:2302/03/2018 10:04:5309:5910:04
b02/03/2018 09:02:2302/03/2018 09:03:5309:0209:03
c02/03/2018 09:03:1302/03/2018 09:05:4309:0309:05

I would like to have a table like that:

    

IDStartDateEndDateOra_inizioOra_fine
a02/03/2018 09:59:2302/03/2018 10:04:5309:5910:04
a02/03/2018 09:59:2302/03/2018 10:04:5310:0010:04
a02/03/2018 09:59:2302/03/2018 10:04:5310:0110:04
a02/03/2018 09:59:2302/03/2018 10:04:5310:0210:04
a02/03/2018 09:59:2302/03/2018 10:04:5310:0310:04
a02/03/2018 09:59:2302/03/2018 10:04:5310:0410:04
b02/03/2018 09:02:2302/03/2018 09:03:5309:0209:03
b02/03/2018 09:02:2302/03/2018 09:03:5309:0309:03
c02/03/2018 09:03:1302/03/2018 09:05:4309:0309:05
c02/03/2018 09:03:1302/03/2018 09:05:4309:0409:05
c02/03/2018 09:03:1302/03/2018 09:05:4309:0509:05

Someone could help me.

Thanks in advance

0 Replies