Re: Handling String date format "0000-00-00 00:00:00" removed in latest version???
Posted by: Simon Haldon
Date: March 02, 2005 08:02AM

I have narrowed this problem down to doing a MAX operation on the date column, as follows:

l_query.append("and posteddate=(select max(posteddate) from forumdetail where forumid=? ");
l_query.append("and deleteddate='1900-01-01 00:00:00')");

Commenting this subquery results in no error. Once again this is only when using the 3.1.x drivers. It works under 3.0.x.

Any advice appreciated. I'm also getting the '.0' suffix dispalyed at the end of the dates returned, as reported by somebody else in another post.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.