subject:"ADDATE Question"

Re: ADDATE Question

2012-07-31 Thread 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 : > Hi, > I just tried this query "SELECT ADDDATE('2008-01-02',

ADDATE Question

2012-07-31 Thread Willy Mularto

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)