<div>
select * from test where update_ts &gt;to_date('15-may-2009 9:00','dd-mon-yyyy hh24:mi);
</div>


select * from test where update_ts >to_date('15-may-2009 9:00','dd-mon-yyyy hh24:mi);

<div>
Is there a way to void the hard coded date 15-may-2009 and use sysdate instead?
</div>


Is there a way to void the hard coded date 15-may-2009 and use sysdate instead?

<div>
<br />
select * from test where update_ts &gt;<br />
trunc(sysdate)+9/24 ;
</div>



select * from test where update_ts >
trunc(sysdate)+9/24 ;

<div>
<div class="content wysiwyg-content">
Need a simple Oracle select to get update_ts is greater than 9AM today. &nbsp;Please see the pseudo code below.<br />
<br />
select * from test where update_ts &gt;&nbsp;9AM today. &nbsp;<br />

</div>
</div>


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.  


SQL for date time is greater than 9AM today

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.