<div>
if you have an index on DateColumn ,this will give you better results <br />
<br />
Select * From yTable Where DateColumn &gt;= dateadd(dd, -30, convert(varchar,getdate(),<wbr />112) &nbsp; )
</div>


if you have an index on DateColumn ,this will give you better results

Select * From yTable Where DateColumn >= dateadd(dd, -30, convert(varchar,getdate(),112)   )

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I have a table with a datetime column and I need help querying this column to show records within the past 30 days.<br />
<br />
Please could anyone share with me the syntax to achieve this.<br />
<br />
Many thanks,<br />
<br />
Rit
</div>
</div>


Hi All,

I have a table with a datetime column and I need help querying this column to show records within the past 30 days.

Please could anyone share with me the syntax to achieve this.

Many thanks,

Rit

Syntax for DateTime column WHERE clause

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.