Skip to content
Advertisement

Aggregate time from 15-minute interval to single hour in SQL

I have below table structure in SQL Server:

Is there a way to group above data into one hour interval instead of 15 minute interval? It has to be based on start and end columns.

Thanks,

Advertisement

Answer

Maybe something like the following using datepart?

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement