<div>
Okay, that's kind of what I had already (it does have date portion), but I was wondering if there was anything a little more elegant. &nbsp;Cheers!
</div>


Okay, that's kind of what I had already (it does have date portion), but I was wondering if there was anything a little more elegant.  Cheers!

<div>
not really.<br />
I have on may servers/database a view/function that returns only the date portion, so it can be used in views/functions easily
</div>


not really.
I have on may servers/database a view/function that returns only the date portion, so it can be used in views/functions easily

<div>
Sorry, just noticed I hadn't accepted the solution - my apologies.
</div>


Sorry, just noticed I hadn't accepted the solution - my apologies.

<div>
<div class="content wysiwyg-content">
I want to return a recordset of results from just today ie:<br />
<br />
SELECT * FROM tblLogUser WHERE LogDate =getDate()<br />
<br />
getDate() includes the time, which I don't want, so how do I easily filter that out?
</div>
</div>


I want to return a recordset of results from just today ie:

SELECT * FROM tblLogUser WHERE LogDate =getDate()

getDate() includes the time, which I don't want, so how do I easily filter that out?

SQL Query - Get Date Range

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

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.