<div>
Thank you very much. This is a new system for me and the previous system I used didn't track the time...it was all set to 00:00:00 so I never had to worry about the time part. <br />
<br />
Thanks again.
</div>


Thank you very much. This is a new system for me and the previous system I used didn't track the time...it was all set to 00:00:00 so I never had to worry about the time part.

Thanks again.

<div>
better check this article out to do things correctly:<br />
<a href="https://www.experts-exchange.com/A_1499.html" rel="ugc">https://www.experts-exchange.com/A_1499.html</a><br />
<br />
above will eventually fail in some setups ...
</div>


better check this article out to do things correctly:
https://www.experts-exchange.com/A_1499.html [https://www.experts-exchange.com/A_1499.html]

above will eventually fail in some setups ...

<div>
<div class="content wysiwyg-content">
I am some what new to SQL and am trying to query a table that has a date_time field in it and filter by that date_time field. The field shows the date and then the time that the line was written to the database.. i.e. '2001-10-31 15:35:24.000'.<br />
<br />
My question is how do I get all data that happened on a specific day (like 10-31-2011) regardless of what the time is? <br />
<br />
Thank you in advance for any help with this.
</div>
</div>


I am some what new to SQL and am trying to query a table that has a date_time field in it and filter by that date_time field. The field shows the date and then the time that the line was written to the database.. i.e. '2001-10-31 15:35:24.000'.

My question is how do I get all data that happened on a specific day (like 10-31-2011) regardless of what the time is? 

Thank you in advance for any help with this.

Date_Time Field in SQL Query (T-SQL)

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.

Microsoft SQL Server 2008

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.