SQL Server 2017

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

CREATE TABLE T
    ([Department] varchar(9), [Time] datetime, [ExtendedPrice] int)
;
    
INSERT INTO T
    ([Department], [Time], [ExtendedPrice])
VALUES
    ('Toys', '2018-11-01 00:00:00', 1205.11),
    ('Toys', '2018-12-02 00:00:00', 1230.27),
    ('Baby Care', '2018-12-01 00:00:00', 6797.95),
    ('Sports', '2019-01-01 00:00:00', 365.8),
    ('Sports', '2019-01-01 00:00:00', 2993.44),
    ('Sports', '2018-12-02 00:00:00', 580.03),
    ('Baby Care', '2019-01-02 00:00:00', 1117.92),
    ('Baby Care', '2019-01-02 00:00:00', 390.75),
    ('soap', '2018-11-01 00:00:00', 3275.25),
    ('Baby Care', '2018-12-01 00:00:00', 367.56)
;

DECLARE @cols AS NVARCHAR(MAX)
SELECT @cols = STUFF((SELECT ',' + QUOTENAME(CONVERT(VARCHAR(10), Time, 105))
                      FROM T
                      GROUP by Time
                      ORDER by Time
               FOR XML PATH(''), TYPE
               ).value('.', 'VARCHAR(MAX)') 
               ,1,1,'');

DECLARE @query AS NVARCHAR(MAX)=
             N'SELECT 
                    ' + @cols + '
              FROM 
              (
                   SELECT 
                       convert(varchar(10),Time,105) Time,
                       ExtendedPrice
                   FROM 
                       T
              ) x
              pivot 
              (
                  sum(ExtendedPrice)
                  for Time in (' + @cols + ')
              ) p ';

EXEC sp_executesql @query;

01-11-2018	01-12-2018	02-12-2018	01-01-2019	02-01-2019
4480	7164	1810	3358	1507