<div>
It comes with Time stamp. so please remove timestamp from the Query.<br />
<br />
Result of Query <br />
<br />
(No column name) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(No column name)<br />
2011-03-01 <b>19:31:07.500</b> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2011-03-31<b> 19:31:07.500</b>
</div>


It comes with Time stamp. so please remove timestamp from the Query.

Result of Query

(No column name)      (No column name)
2011-03-01 19:31:07.500      2011-03-31 19:31:07.500

<div>
DateOfOrder BETWEEN convert( datetime, -datediff(day,dateadd(mont<wbr />h,-1,getda<wbr />te()),day(<wbr />getdate())<wbr />-1) )<br />
&nbsp; &nbsp; AND convert( datetime, -datediff(day,getdate(),da<wbr />y(getdate(<wbr />))) )
</div>


DateOfOrder BETWEEN convert( datetime, -datediff(day,dateadd(month,-1,getdate()),day(getdate())-1) )
    AND convert( datetime, -datediff(day,getdate(),day(getdate())) )

<div>
Please try the following:<br />
<br />

<pre><code id="code-20-35447911-1">CAST(DateOfOrder as date) BETWEEN dateadd(month, -1, dateadd(day, 1 - DAY(getdate()), CAST(getdate() as date))),
                              AND dateadd(day, -DAY(getdate()), CAST(getdate() as date))</code></pre>
</div>


Please try the following:



CAST(DateOfOrder as date) BETWEEN dateadd(month, -1, dateadd(day, 1 - DAY(getdate()), CAST(getdate() as date))),
                              AND dateadd(day, -DAY(getdate()), CAST(getdate() as date))

<div>
<div class="content wysiwyg-content">
I am using the below sql syntax to pull data for the previous month, and its not pulling all data for the month. &nbsp;How can I adjust the below syntax?<br />
<br />
DateOfOrder BETWEEN dateadd(month, -1, (dateadd ( day, -(DATEPART(day, getdate()))+1, getdate() ))) <br />
&nbsp; &nbsp; AND (dateadd(day,-(DATEPART(da<wbr />y,getdate(<wbr />)) ),getdate()) ) 
</div>
</div>


I am using the below sql syntax to pull data for the previous month, and its not pulling all data for the month.  How can I adjust the below syntax?

DateOfOrder BETWEEN dateadd(month, -1, (dateadd ( day, -(DATEPART(day, getdate()))+1, getdate() ))) 
    AND (dateadd(day,-(DATEPART(day,getdate()) ),getdate()) ) 

Sql Date Syntax

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.