group by 30 min. intervals

[karen4201]

Hi,

I'd like to organize my data based on a datatime field grouped by 30 minute intervals.

I'm thinking about using a CASE statement that would look at the minute and if 0..30 then it would get 1, otherwise it would get 2...so 1 is the first half hour, and 2 is the second half hour. There are probably easier ways to do the 30 minute intervals.

Any suggestions on how to do this?

 

[mrdenny]

That's a fairly normal way to do it.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com