<div>
Cannot thank you enough worked pefect!
</div>


<div>
select * from &lt;table_name&gt; where req_dt &lt;= trunc(sysdate)+14/24 
</div>


select * from <table_name> where req_dt <= trunc(sysdate)+14/24

<div>
Just getting ready to post the alternative... &nbsp;you beat me<br />
<br />
&nbsp;trunc(sysdate)+14/24 
</div>


Just getting ready to post the alternative...  you beat me

 trunc(sysdate)+14/24

<div>
<div class="content wysiwyg-content">
Ok I know this is going to be an easy one and I just do not deal with time that often in my current work.<br />
<br />
I have a column called REQ_DT that is a DATE column and holds the date an account was requested (ex 2/27/2011 10:16:44 PM) as well as the time. I just need to have a where clause that selects all of the REQ_DT's where the REQ_DT is less than or equal to the CURRENT_DATE 2:00:00 pm<br />
<br />
So basically all of the requests that were submitted before today at 2:00pm. Hope that anyone can assist.
</div>
</div>


Ok I know this is going to be an easy one and I just do not deal with time that often in my current work.

I have a column called REQ_DT that is a DATE column and holds the date an account was requested (ex 2/27/2011 10:16:44 PM) as well as the time. I just need to have a where clause that selects all of the REQ_DT's where the REQ_DT is less than or equal to the CURRENT_DATE 2:00:00 pm

So basically all of the requests that were submitted before today at 2:00pm. Hope that anyone can assist.

Oracle Where Clause Current_Date and Time

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.