How to Group by Just Date Portion Of DateTime Field

Author: aghausman | Posted: 27. February 2009 01:42 4

There are times when we need to group by the table with the date. But Datetime field also contain time part which is very deep. So, there is no way you can group by datetime field and see correct records because it will group by including the time portion of DateTime field.

So, to get rid off the time portion in group by clause here is a quick query.

        1: select  dateadd(dd,0, datediff(dd,0,dateCreated)) as Date,count(*) TotalCount  from tblRecords          2: group by dateadd(dd,0, datediff(dd,0,dateCreated))   

Tags: How-to-group-by-date-portion-of-DateTime-field

SQL Server | TSQL

Maintain Scroll Position With Asp.net Validation Controls.In this post I will demonstrate you how to maintain the scroll position of asp.net validation contro...Validate username using custom validation (AJAX)In this post, I will explain you how to have an ajax call on custom validator control and check for ...Get Primary key on Row Command (GridView) Some days back I got a query from one of my fellow, regarding a very normal situation I mean that’s...

Comments

Deep Patel , on 8/3/2009 3:31:11 AM Said:

SQL=" select datevalue(datetimefield) AS date2 ,count(id) as cntid from tablename group by datevalue(datetimefield) order by datevalue(datetimefield) desc"

exercise to enlarge penis , on 9/23/2009 1:17:53 AM Said: