Message-ID: <433185EE.405@bea.com> Date: Wed, 21 Sep 2005 09:10:22 -0700 From: Joe Weinstein User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server To: suresh Subject: Re: JDBC Timestamp comparison References: <1127316579.168952.7300@g14g2000cwa.googlegroups.com> In-Reply-To: <1127316579.168952.7300@g14g2000cwa.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 216.148.48.12 X-Trace: news.beasys.com 1127319024 216.148.48.12 (21 Sep 2005 09:10:24 -0700) Organization: BEA SYSTEMS Inc Lines: 31 Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!nx02.iad01.newshosting.com!newshosting.com!uunet!dca.uu.net!spool.news.uu.net!ash.uu.net!news.beasys.com!not-for-mail Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251941 suresh wrote: > 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 Hi. Can you show me the actual JDBC code? What JDBC driver are you using? thanks, Joe Weinstein at BEA (followups could be posted to the BEW jdbc newsgroup)