<div>
It is quick, easy and working solution! Thanks!!
</div>


It is quick, easy and working solution! Thanks!!

<div>
you can compare them directly in sql if not hardcoding values so:<br />
<br />
SELECT &nbsp;sysdate - SYSTIMESTAMP FROM dual<br />
select * from table where date_col &gt;&nbsp;timestamp_col<br />
<br />
<a href="http://www.psoug.org/reference/timestamp.html" rel="ugc">http://www.psoug.org/reference/timestamp.html</a>
</div>


you can compare them directly in sql if not hardcoding values so:

SELECT  sysdate - SYSTIMESTAMP FROM dual
select * from table where date_col > timestamp_col

http://www.psoug.org/reference/timestamp.html [http://www.psoug.org/reference/timestamp.html]

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
&nbsp; This is an urgent request. I need compare the colume of datetime type (e.g. 06/21/2008 11:30:00pm) with a timestampe like (e.g 06/21/2008 10:40:35). what is quick way to do that?<br />
<br />
select * from mytable<br />
where mydatetime &gt;&nbsp;'06/20/2008 10:40:35pm'
</div>
</div>


Experts,

  This is an urgent request. I need compare the colume of datetime type (e.g. 06/21/2008 11:30:00pm) with a timestampe like (e.g 06/21/2008 10:40:35). what is quick way to do that?

select * from mytable
where mydatetime > '06/20/2008 10:40:35pm'

Compare Oracle Date TIME with sql

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.