<div>
Btw, the above only works for MSSQL 2012 and superior.
</div>


Btw, the above only works for MSSQL 2012 and superior.

<div>
Thank you. I have one more question if you don't mind, because I am confused about how this works. If i needed the records for 15-30 Days, would I use:<br />
<br />
&nbsp;WHERE myDate &gt;= CAST(GETDATE()-30 AS DATE) AND myDate &lt;&nbsp;CAST(GETDATE()-14 AS DATE)<br />
<br />
?
</div>


Thank you. I have one more question if you don't mind, because I am confused about how this works. If i needed the records for 15-30 Days, would I use:

 WHERE myDate >= CAST(GETDATE()-30 AS DATE) AND myDate < CAST(GETDATE()-14 AS DATE)

?

<div>
<blockquote>
Btw, the above only works for MSSQL 2012 and superior. 
</blockquote>
<br />
Good approach. FWIW, should work in 2008+. &nbsp;IIRC, that is when data type DATE was added.
</div>


> Btw, the above only works for MSSQL 2012 and superior.


Good approach. FWIW, should work in 2008+.  IIRC, that is when data type DATE was added.

<div>
<div class="content wysiwyg-content">
Hello, can some help me understand how to query the below date ranges with MS SQL?<br />
<br />
The field is called &quot;myDate&quot; . So if Today's date is 11/16/16.....<br />
<br />
I need to get records that were created from midnight of the current day, through right now. (11/16/16 12AM - now)<br />
<br />
Next, I need to get records created from midnight of the previous day, to records created at midnight of the current day. (11/15/16 12am - 11/15/16 23:59pm)<br />
<br />
Next, I need to get records created between 2 days ago and 14 days ago. (11/2/16 12am - 11/13/16 23:59pm)<br />
<br />
I know this is confusing, but can someone assist? Thank you.
</div>
</div>


Hello, can some help me understand how to query the below date ranges with MS SQL?

The field is called "myDate" . So if Today's date is 11/16/16.....

I need to get records that were created from midnight of the current day, through right now. (11/16/16 12AM - now)

Next, I need to get records created from midnight of the previous day, to records created at midnight of the current day. (11/15/16 12am - 11/15/16 23:59pm)

Next, I need to get records created between 2 days ago and 14 days ago. (11/2/16 12am - 11/13/16 23:59pm)

I know this is confusing, but can someone assist? Thank you.

How to query date ranges with SQL

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.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.