BEGIN
  DECLARE LOCAL TEMPORARY TABLE #Test (
    StartDate date NOT NULL,
    DayOfWeek char( 3 ) NOT NULL,
    NumDayOfWeek tinyint NOT NULL,
    StartTime char( 5 ) NOT NULL,
    PRIMARY KEY (StartDate, DayOfWeek, StartTime)
  ) NOT TRANSACTIONAL;

  INSERT INTO #Test
    SELECT '2005-01-01', 'Sun',  1 , '05:00'
    UNION ALL
    SELECT '2005-01-01', 'Sun',  1 , '08:00'
    UNION ALL
    SELECT '2005-01-01', 'Mon',  2 , '07:00'
    UNION ALL
    SELECT '2005-01-01', 'Mon',  2 , '13:00'
    UNION ALL
    SELECT '2005-01-02', 'Sun',  2 , '08:00'
    UNION ALL
    SELECT '2005-01-02', 'Fri',  6 , '06:00'
    UNION ALL
    SELECT '2005-01-02', 'Fri',  6 , '14:00';

  SELECT StartDate, List(DayOfWeek || ': ' || ListTime, '\n' ORDER BY NumDayOfWeek) AS Str
  FROM (
    SELECT StartDate, DayOfWeek, NumDayOfWeek, List(StartTime, ',' ORDER BY StartTime) AS ListTime
    FROM #Test
    GROUP BY StartDate, DayOfWeek, NumDayOfWeek
  ) AS x
  GROUP BY StartDate
  ORDER BY StartDate;
END;