SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Create Table #Test (Id Int Identity(1,1), Category Varchar(100), DateTimeStamp DateTime)

Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 01:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 02:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 03:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 04:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 05:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 06:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 07:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 08:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 09:00:13.503')
        Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 10:00:13.503')  
        Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 11:00:13.503')

11 rows affected

category	(No column name)	(No column name)
c1	2019-08-13 01:00:13.503	2019-08-13 05:00:13.503
c2	2019-08-13 06:00:13.503	2019-08-13 10:00:13.503
c1	2019-08-13 11:00:13.503	2019-08-13 11:00:13.503