<div>
Aaron is correct. &nbsp;If you have timestamps and want to ensure that you don't get different results based on time you run query do this to force date to midnight.<br />
<br />
DELETE Friends<br />
WHERE DateCreated &lt;&nbsp;DATEADD(DAY, -30, DATEDIFF(DAY, 0, GETDATE()))
</div>


Aaron is correct.  If you have timestamps and want to ensure that you don't get different results based on time you run query do this to force date to midnight.

DELETE Friends
WHERE DateCreated < DATEADD(DAY, -30, DATEDIFF(DAY, 0, GETDATE()))

<div>
<div class="content wysiwyg-content">
Hello, I need to delete a row if the datecreated is greater than 30 days.<br />
<br />
Declare @Today as datetime set @Today = GetDate()<br />
Delete Friends <br />
where dateCreated = ?
</div>
</div>


Hello, I need to delete a row if the datecreated is greater than 30 days.

Declare @Today as datetime set @Today = GetDate()
Delete Friends 
where dateCreated = ?

help with datedif

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.