<div>
Please correct todate () into to_date()<br />

</div>


<div>
<div class="content wysiwyg-content">
I am attempting to query an Oracle database, and I am new to Oracle syntax. (I am used to MS SQL Server and the local functions for that DBMS.) When I am attempting to search for all transactions that occurred between the dates of 9/1/2011 and 9/5/2011, I am ending up with the error message:<br />
&quot;SQL Error: ORA-00933: SQL command not properly ended<br />
00933. 00000 - &nbsp;&quot;SQL command not properly ended&quot;<br />
*Cause: &nbsp; &nbsp;<br />
*Action:&quot;<br />
<br />
The SQL code that I am attempting to use is listed below:<br />
&quot;Select * From results r Where r.txn_date BETWEEN todate('09/01/2011','mm/dd<wbr />/yyyy') AND todate('09/05/2011','mm/dd<wbr />/yyyy')&quot;<br />
<br />
Any help that could be provided would be greatly appreciated. 
</div>
</div>


I am attempting to query an Oracle database, and I am new to Oracle syntax. (I am used to MS SQL Server and the local functions for that DBMS.) When I am attempting to search for all transactions that occurred between the dates of 9/1/2011 and 9/5/2011, I am ending up with the error message:
"SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:"

The SQL code that I am attempting to use is listed below:
"Select * From results r Where r.txn_date BETWEEN todate('09/01/2011','mm/dd/yyyy') AND todate('09/05/2011','mm/dd/yyyy')"

Any help that could be provided would be greatly appreciated. 

Syntax for How to Search Between Dates in Oracle

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.