how to round date to day? t-sql

Question

I have an Orders table (Date is the time of the order up to a minute. CountMaterial is the amount of materials used)

How do i round off order time to day. To see how much material was used per day?

Anatol 3,052 one 13 37 · Accepted Answer · 2016-12-01T13:40:42

SELECT CAST(GETDATE() AS DATE);

instead of getdate substitute your date

Alex 6,232 five nineteen 29 · Answer 2 · 2016-12-01T13:48:46

to_char (Date, 'DD / MM / YYYY')

 SELECT SUM(CountMaterial), TO_CHAR(Date, 'DD/MM/YYYY') FROM Orders GROUP BY TO_CHAR(Date, 'DD/MM/YYYY')

2 answers 2