Create DateTime table with Grouped minutes columns - SQL
Im trying to create a SQL table that has a datetime (date , hour and minute only) column starting from say 2017-11-17T00:00 and columns with heading say 30min , 45min, 77min, 240min, 343min which is basically grouping the datetime column in those specific minutes .
But the groupings only happen between 00:00 and 23:59 each day , and then starts the grouping again at 00:00 onwards .
have spreadsheet with starting what it should look like , would like to have about 3 years datetime from 2017-11-17 please :-) datetimeGrouped.xlsx
Open in new window