How to convert UNIX TIMESTAMP to DATE in mysql

Table : info
============================
id      name    dob
============================
1 test1 1235994659
2 test2 1235994707
============================

$sql = "SELECT DATE(FROM_UNIXTIME(dob)) AS birthdate FROM info WHERE 1=1";

OUTPUT :
-------------
birthdate
========
2009-03-02
2009-03-02