Comments on: Grouping datetime by date in T-SQL

By: Ryan Hennig

Ryan Hennig — Fri, 11 Jun 2010 04:08:27 +0000

I had a similar situation at work, where I needed to group by intervals of 10 minutes. I wrote a handy UDF to do this which can bucket datetime into any interval of minutes. You could use like this:

SELECT dbo.BucketDateTime(GETDATE(), 60 * 24)

The implementation is on my blog:
http://ryancoder.blogspot.com/2010/06/bucket-datetimes-in-t-sql.html

By: James

James — Wed, 26 May 2010 23:58:44 +0000

Great thanks mate. this made my day

By: Joaquim Félix

Joaquim Félix — Fri, 08 Jan 2010 14:19:45 +0000

This example was great. I have been a Oracle (and PL/SQL) developer for last 9 years and now I’m struggling my way inside SQL Server (and T-SQL).
Your post was, and is, a tremendous help.
Thank You.

By: Phil Karras

Phil Karras — Tue, 02 Dec 2008 16:57:34 +0000

I’m sure there were many others like me who searched, found, & used your ideas to get a job done but then never said thanks.

Thanks!

Now I need to count how many values have been added to another field on a given date, I don’t care what the values are as long as they are not NULL.

By: Matt

Matt — Tue, 04 Nov 2008 20:35:42 +0000

Thanks very much! Works like a charm.

By: maatthias

maatthias — Thu, 11 Sep 2008 18:14:59 +0000

That first query is very clever. Thanks for this.