Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Hans Castorp Newsgroups: comp.lang.java.databases Subject: Re: Problem with JDBC driver and MySQL date_format function Date: Sun, 15 May 2011 13:37:30 +0200 Lines: 12 Message-ID: <939s7hFsqnU1@mid.individual.net> References: <9340c7F40hU1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net sfbeib8ytqj11twOcF/2uQOH9GesqhrXb6uiAmZrree53s58I= Cancel-Lock: sha1:wFwOr9b7kDyiF8GqcHwz+O5WPy0= User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 In-Reply-To: <9340c7F40hU1@mid.individual.net> Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:446 Jens Riedel wrote on 13.05.2011 08:11: > Since I updated my mysql driver version 3 to version 5 > (mysql-connector-java-5.1.7-bin.jar) I get funny strings like > "[B@b57546" when I format datetime columns with the date_format > function instead of the correct formatted date string. > That sure looks like the default toString() output of java.lang.Object What exactly are you passing to the date_format() function? Show us your SQL statement and the Java code