DateTime nach Wochentag gruppieren

[omata]

SQL-Code:

SELECT YEAR(indate) AS jahr, 
       MONTH(indate) AS monat, 
       DAY(indate) AS tag, 
       SUM(anzahl) AS anzahl
FROM messwerte
WHERE indate > :MD1 
GROUP BY YEAR(indate), MONTH(indate), DAY(indate)

SQL-Code:

SELECT DateSerial(YEAR(indate), MONTH(indate), DAY(indate)) AS datum, 
       SUM(anzahl) AS anzahl
FROM messwerte
WHERE indate > :MD1 
GROUP BY YEAR(indate), MONTH(indate), DAY(indate)