<div>
I should add, if you prefer to be explicit regarding the date conversion, then you can do this instead:<br />
<br />
between convert(date,'2013-04-01')<wbr /> and convert(date,'2013-05-10')<wbr /><br />
<br />
-- not sure about sql 2005, will work in 2008
</div>


I should add, if you prefer to be explicit regarding the date conversion, then you can do this instead:

between convert(date,'2013-04-01') and convert(date,'2013-05-10')

-- not sure about sql 2005, will work in 2008

<div>
<div class="content wysiwyg-content">
Dear all,<br />
<br />
We have an oracle statement here and this will will execute in MS SQL side.<br />
<br />
&quot;to_date('2013-04-01','YYY<wbr />Y-MM-DD') and to_date('2013-05-10','YYYY<wbr />-MM-DD')&quot;<br />
<br />
but I try to run it from MS SQL and see what takes it so long time to return.<br />
<br />
how can I convert it to t-SQL ?
</div>
</div>


Dear all,

We have an oracle statement here and this will will execute in MS SQL side.

"to_date('2013-04-01','YYYY-MM-DD') and to_date('2013-05-10','YYYY-MM-DD')"

but I try to run it from MS SQL and see what takes it so long time to return.

how can I convert it to t-SQL ?

T-SQL convertion

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.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.