<div>
delete from tborders <br />
where dteOrderDate &gt;= convert(smalldatetime, '22/03/2006', 103) <br />
AND dteOrderDate &lt;&nbsp;dateadd(day, 1, convert(smalldatetime, '22/03/2006', 103) )<br />

</div>


delete from tborders
where dteOrderDate >= convert(smalldatetime, '22/03/2006', 103)
AND dteOrderDate < dateadd(day, 1, convert(smalldatetime, '22/03/2006', 103) )


<div>
Thanks for the fast reply angelIII, unfortunately your query returned the same error.
</div>


Thanks for the fast reply angelIII, unfortunately your query returned the same error.

<div>
That did the trick aneeshattingal, thank you very much.
</div>


That did the trick aneeshattingal, thank you very much.

<div>
<div class="content wysiwyg-content">
I'm having a problem with mssql. I accidentally inserted a value into a smalldatetime field using getdate(). When I try to delete the row using queries like <br />
<br />
delete from tborders where nOrderID=1<br />
<br />
or<br />
<br />
delete from tborders where Convert(Varchar,dteOrderDa<wbr />te,103) = '22/03/2006'<br />
<br />
It gives me the error;<br />
<br />
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.<br />
<br />
Is there another delete statement I could use to get rid of this row?<br />
<br />
Thanks in advance for your help.
</div>
</div>


I'm having a problem with mssql. I accidentally inserted a value into a smalldatetime field using getdate(). When I try to delete the row using queries like 

delete from tborders where nOrderID=1

or

delete from tborders where Convert(Varchar,dteOrderDate,103) = '22/03/2006'

It gives me the error;

The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

Is there another delete statement I could use to get rid of this row?

Thanks in advance for your help.

Cannot delete row due to: out-of-range smalldatetime value

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.