JDBC Timestamp comparison

From: suresh <softgem_at_gmail.com>
Date: 21 Sep 2005 08:29:39 -0700
Message-ID: <1127316579.168952.7300@g14g2000cwa.googlegroups.com>

I am trying to compare timestamp with CURRENT_TIMESTAMP and oracle is throwing this error ORA-01866: the datetime class is invalid.

My query,

select * from message_log where log_timestamp >= CURRENT_TIMESTAMP -12/24

where log_timestamp is of TIMESTAMP datatype.

This works fine with sqlplus but it doesn't work from JDBC. Also this seems to be some driver issue because it works in another environment where oracle oci client is installed. I am using weblogic 7.0 on solaris server.

Any one has any clue.

Thanks,
Suresh Received on Wed Sep 21 2005 - 10:29:39 CDT