SELECT records from yesterday 6 PM to today Oracle PLSQL

IN Oracle 10 G, How do I SELECT all records from yesterday 6 PM to today current time.

What would be the PL/SQL to do this?
codemonkey2480Asked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
select * from table where date_column >= to_date(to_char(sysdate-1,'MM/DD/YYYY') || ' 18:00:00','MM/DD/YYYY HH24:MI:SS');
0
 
slightwv (䄆 Netminder) Commented:
Also PL/SQL is Oralce's procedural language.  This can be done is simple SQL.
0
 
codemonkey2480Author Commented:
My bad! Thanks for the SQL.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.