<div>
You can use Month function<br />
<br />
from BOL<br />
<br />
MONTH<br />
Returns an integer that represents the month part of a specified date.<br />
<br />
Syntax<br />
MONTH ( date ) <br />

</div>


You can use Month function

from BOL

MONTH
Returns an integer that represents the month part of a specified date.

Syntax
MONTH ( date )


<div>
However, it's better to use a date range expression that SQL can use to search an index (if one exists now or in the future):<br />
<br />
SELECT ...<br />
FROM ...<br />
WHERE date &gt;= '20061001' AND date &lt;&nbsp;'20061101' &nbsp;--to get Oct 2006 only
</div>


However, it's better to use a date range expression that SQL can use to search an index (if one exists now or in the future):

SELECT ...
FROM ...
WHERE date >= '20061001' AND date < '20061101'  --to get Oct 2006 only

<div>
<div class="content wysiwyg-content">
i need a query that will let me select distinct months, from a column that contains the date in the format: 10/20/2006 12:00:00 AM<br />
<br />
<br />
<br />

</div>
</div>


i need a query that will let me select distinct months, from a column that contains the date in the format: 10/20/2006 12:00:00 AM





Selecting specific dates - T- SQL

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.