Sort by day, ignoring hours and minutes

December 19, 2022

I have a little problem for you. I would like to sort by day, but if several with different times are sorted on the day, it separates them. How do I get it out that he only shows all day by day

My date field looks like this

Datum                         weight
2022-12-09 07:12:49.000       2150
2022-12-09 08:15:49.000       1250

My query

Select FORMAT(Datum, 'dd/MM/yyyy', 'de-DE') as Datum, SUM(weight)
FROM [Produktionsdaten].[dbo].[produktionedelstahl]
WHERE Anlage IN ('Bonak 2')
  AND YEAR(Datum)=YEAR(CURRENT_TIMESTAMP)
  AND MONTH(Datum)=MONTH(CURRENT_TIMESTAMP)
group BY (Datum)

I want the day to be summarized

Datum           weight
12-09-2022      3400

>Solution :

I think you were nearly there – just change the last line

Select FORMAT(Datum, 'dd/MM/yyyy', 'de-DE') as Datum, SUM(weight)
FROM [Produktionsdaten].[dbo].[produktionedelstahl]
WHERE Anlage IN ('Bonak 2')
  AND YEAR(Datum)=YEAR(CURRENT_TIMESTAMP)
  AND MONTH(Datum)=MONTH(CURRENT_TIMESTAMP)
group BY FORMAT(Datum, 'dd/MM/yyyy', 'de-DE')