Oracle Where Clause Current_Date and Time

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.
mjfigurAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Try this:
select * from table were req_dt <= to_date(to_char(sysdate,'MM/DD/YYYY') || '14:00:00','MM/DD/YYYY HH24:MI:SS');
0
 
mjfigurAuthor Commented:
Cannot thank you enough worked pefect!
0
 
slightwv (䄆 Netminder) Commented:
Glad to help.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
AkenathonCommented:
select * from <table_name> where req_dt <= trunc(sysdate)+14/24
0
 
AkenathonCommented:
Oops... too late :-)
0
 
slightwv (䄆 Netminder) Commented:
Just getting ready to post the alternative...  you beat me

 trunc(sysdate)+14/24
0
All Courses

From novice to tech pro — start learning today.