<div>
<br />
select * from orders where dateordered &nbsp;CONVERT(DATETIME, @Date1,103) AND CONVERT(DATETIME, @Date2,103)
</div>



select * from orders where dateordered  CONVERT(DATETIME, @Date1,103) AND CONVERT(DATETIME, @Date2,103)

<div>
<div class="content wysiwyg-content">
<br />
orders.dateordered is datatime in the form yyyy-mm-dd<br />
2010-01-01 18:04:14.000<br />
2009-12-29 06:11:22.000<br />
2010-01-02 05:55:21.000<br />
<br />
$date1 is 31/01/2010 &nbsp;dd/mm/yyyy<br />
select * from orders where dateordered is between $date1 and $date2<br />
<br />
<br />

</div>
</div>



orders.dateordered is datatime in the form yyyy-mm-dd
2010-01-01 18:04:14.000
2009-12-29 06:11:22.000
2010-01-02 05:55:21.000

$date1 is 31/01/2010  dd/mm/yyyy
select * from orders where dateordered is between $date1 and $date2




yyyy-mmm-dd to dd/mm/yyyy

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.