Re: ADDATE Question

[yoku ts]

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)
>
>
>
>
>
>
>
>
>