<div>
<div class="content wysiwyg-content">
Have a oracle table which has a date field in it. &nbsp;Trying to figure out how to pull the information back where date field equals current date<br />
<br />
TABLE_A<br />
Field Name &nbsp; &nbsp; &nbsp; &nbsp; Type &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Length<br />
Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; varchar2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50<br />
Date_entered &nbsp; &nbsp; Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7<br />
<br />
Just wanting something like<br />
Select * from TABLE_A where Date_entere = sysdate;<br />
<br />
Not working though...
</div>
</div>


Have a oracle table which has a date field in it.  Trying to figure out how to pull the information back where date field equals current date

TABLE_A
Field Name         Type               Length
Name                 varchar2          50
Date_entered     Date                  7

Just wanting something like
Select * from TABLE_A where Date_entere = sysdate;

Not working though...

ORACLE SQL TO check date column against current date

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.