<div>
Select First_Name FROM students <br />
WHERE EntryDate &gt;= '2010-08-26' &nbsp;<br />
&nbsp; AND EntryDate &lt;&nbsp; '2010-08-27' &nbsp;<br />

</div>


Select First_Name FROM students
WHERE EntryDate >= '2010-08-26'  
  AND EntryDate <  '2010-08-27'  


<div>
&gt;&gt;EntryDate &gt;= '2010-08-26' &nbsp;<br />
<br />
I always recommend explicit data type conversions. &nbsp;Then there can be no confusion.<br />

</div>


>>EntryDate >= '2010-08-26'  

I always recommend explicit data type conversions.  Then there can be no confusion.


<div>
I just used the second option you gave. &nbsp;I didnt know you could explicitly define it. &nbsp;Thanks!
</div>


I just used the second option you gave.  I didnt know you could explicitly define it.  Thanks!

<div>
<div class="content wysiwyg-content">
We have an Oracle backend database that I am trying to select records from where the field EntryDate &gt;= 08/26/2010 &nbsp; <br />
<br />
EntryDate is in the DateTime format, so not a string, and I have been unsuccesful and forming a query to accomplish this. &nbsp;<br />
<br />
If I output the data to the screen for a praticular record I get <br />
<br />
2010-08-26 00:00:00<br />
<br />
even trying a selection of<br />
<br />
Select First_Name FROM students WHERE EntryDate ='08/26/2010'<br />
or<br />
Select First_Name FROM students WHERE EntryDate ='2010-08-26 00:00:00' &nbsp;<br />
<br />
I get no results. &nbsp;Can anyone help me form a query to get this accomplished.
</div>
</div>


We have an Oracle backend database that I am trying to select records from where the field EntryDate >= 08/26/2010   

EntryDate is in the DateTime format, so not a string, and I have been unsuccesful and forming a query to accomplish this.  

If I output the data to the screen for a praticular record I get 

2010-08-26 00:00:00

even trying a selection of

Select First_Name FROM students WHERE EntryDate ='08/26/2010'
or
Select First_Name FROM students WHERE EntryDate ='2010-08-26 00:00:00'  

I get no results.  Can anyone help me form a query to get this accomplished.

SQL datetime where selection

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.