From: yoku ts
Date: August 1 2012 5:00am
Subject: Re: ADDATE Question
List-Archive: http://lists.mysql.com/mysql/227920
Message-Id: <CAHB5oTPk84wx7carPzojrMtc_OjvbNyTJK1Nn9_WTcUA0TkeRw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

hello,

`323030382d30322d3032' is hexadecimal expression of `2008-02-02'.

but i don't know why your MySQL returns a result in hexadecimal.
don't you have any idea about hexadecimal in your program?


yoku ts.


2012/8/1 Willy Mularto <sangprabv@stripped>:
> Hi,
> I just tried this query "SELECT ADDDATE('2008-01-02', 31);" and MySQL returns "323030382d30322d3032", while it should be "2008-02-02" Is there something wrong?
>
>
>
> Willy Mularto
> F300HD+MR18DE (NLC1725)
>
>
>
>
>
>
>
>
>