How can I group by date time column without taking time into consideration

Question

I have a bunch of product orders and I m trying to group by the date and sum the quantity for that date  How can I group by the month day year without taking the time part into consideration   3 8 2010 7 42 00 should be grouped with 3 8 2010 4 15 00

User · Answer

In pre Sql 2008 By taking out the date part     GROUP BY CONVERT CHAR 8  DateTimeColumn 10

User · Answer

I believe you need to group by   in that day of the month of the year    so why not using TRUNK DATE functions    The way it works is described below    Group By DATE TRUNC  day     occurred at time

User · Answer

Here is the example works fine in oracle  select to char columnname   DD MON yyyy    count    from table name group by to char createddate   DD MON yyyy

User · Answer

CAST datetime field to date  select  CAST datetime field as DATE   count    as count from table group by CAST datetime field as DATE

User · Answer

GROUP BY DATE date time column

User · Answer

Here s an example that I used when I needed to count the number of records for a particular date without the time portion   select count convert CHAR 10   dtcreatedate  103    convert char 10   dtcreatedate  103  FROM dbo tbltobecounted GROUP BY CONVERT CHAR 10  dtcreatedate 103  ORDER BY CONVERT CHAR 10  dtcreatedate 103

User · Answer

Cast Convert the values to a Date type for your group by   GROUP BY CAST myDateTime AS DATE

User · Answer

GROUP BY DATEADD day  DATEDIFF day  0  MyDateTimeColumn   0    Or in SQL Server 2008 onwards you could simply cast to  Date  as  Oded suggested   GROUP BY CAST orderDate AS DATE

[sql] How can I group by date time column without taking time into consideration

Examples related to sql

Examples related to sql-server

Examples related to tsql

Examples related to sql-server-2008