Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Comparing 2 Timestamps in an SQL Query

392094Apr 9 2003 — edited Apr 10 2003

Hi all,

I'm connecting to an Oracle Database by JDBC und now I'm trying to compare the stored Timestamp-Object with another Java-TimestampObject. My Query looks like that:

select *
from table
where date.getTimestamp() > old_date

The first 'date' names the head of column und 'old_date' is a Java-Timestamp. I receive the following error:
ORA-00933: The Query could not be correctly ended

Who can help me???

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2003

Added on Apr 9 2003

#general-database-discussions

4 comments

268 views