Get Hourly Data from SQL Server DateTime Field


SELECT DATEPART(dd, SurveyorActivityDateTime) AS myday, 
       DATEPART(hh, SurveyorActivityDateTime) AS myhour, 
       Count(RetailerId) AS Quantity
FROM [RobiPosMapping].[dbo].[Retailer]
WHERE CAST(SurveyorActivityDateTime AS DATE) = '2015-06-04'
GROUP BY DATEPART(dd, SurveyorActivityDateTime), 
         DATEPART(hh, SurveyorActivityDateTime)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s