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 <sangpr...@gmail.com>: > 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) > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql