Re: Date functions return strings
Posted by: Mark Matthews
Date: April 26, 2005 10:31AM

chris wrote:
> Ok, could somebody maybe tell me at least if they
> do not have this problem?
> Another example,
> select date(mydatecol) as mydate from mytable
> JDBC metadata would say this is a string. This is
> really screwing everything up. Any hints would be
> much appreciated, if even just to say that you
> don't have that problem and this is unexpected.
> Thanks


This is a known server issue (and is listed in the bugs database multiple times at The only workaround currently is to ask for the type you want, not depend on ResultSet.getObject() to return the type you expect when using functions.

- Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools

Options: ReplyQuote

Written By
April 20, 2005 01:03PM
April 21, 2005 10:12AM
Re: Date functions return strings
April 26, 2005 10:31AM

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.