<div>
SELECT &nbsp;CONVERT(varchar(6), datecolumn, 112) +'01' as date, sum(hrs) totl<br />
from yourTable<br />
GROUP BY CONVERT(varchar(6), datecolumn, 112) <br />
<br />
<br />
** Note : in future, it will always better if you provide the table structure or sample data'
</div>


SELECT  CONVERT(varchar(6), datecolumn, 112) +'01' as date, sum(hrs) totl
from yourTable
GROUP BY CONVERT(varchar(6), datecolumn, 112)


** Note : in future, it will always better if you provide the table structure or sample data'

<div>
Did you try the first one ?
</div>


<div>
<div class="content wysiwyg-content">
I have a table with a list of dates and hours associated with those dates. I want to produce a report that sums the hours for a month. I want to change all the dates for a month to the same date for a group by statement. How can I accomplish this?
</div>
</div>


I have a table with a list of dates and hours associated with those dates. I want to produce a report that sums the hours for a month. I want to change all the dates for a month to the same date for a group by statement. How can I accomplish this?

Help with between statement in a select

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.