Oracle Where Clause Current_Date and Time
Posted on 2011-03-11
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.