SQL for date time is greater than 9AM today

Need a simple Oracle select to get update_ts is greater than 9AM today.  Please see the pseudo code below.

select * from test where update_ts > 9AM today.  
ewang1205Asked:
Who is Participating?
 
Shaju KumbalathConnect With a Mentor Deputy General Manager - ITCommented:
if u want to check it every day use
select * from test where update_ts >
trunc(sysdate)+9/24 ;
0
 
Shaju KumbalathDeputy General Manager - ITCommented:
select * from test where update_ts >to_date('15-may-2009 9:00','dd-mon-yyyy hh24:mi);
0
 
ewang1205Author Commented:
Is there a way to void the hard coded date 15-may-2009 and use sysdate instead?
0
 
Shaju KumbalathDeputy General Manager - ITCommented:

select * from test where update_ts >
trunc(sysdate)+9/24 ;
0
 
reb73Connect With a Mentor Commented:
or

select * from test where update_ts > dateadd('h',9,trunc(SYSDATE, 'DDD'));
0
All Courses

From novice to tech pro — start learning today.