Date functions returning Strings

Hi, I'm using MM JDBC driver version 2.0.4 to access a MySQL database 3.23.40 on Solaris 2.8. When I do the following query "SELECT NOW()", I always get String data and not Date data when fetching the data. Is it normal that Date functions returns a String? Is this a MySQL bug? Th

Problem with MySQL

Description: I use the MM JDBC driver version 2.0.4 to access my MySQL database from my Java app. If I do "SELECT NOW()", it returns a String object and not a Date object. I tried to call different functions (e.g. "SELECT DATE_ADD(NOW(), INTERVAL 0 SECOND)") in order to have a Date in m

Why DATE functions return a String in SELECT

>Description: I use the MM JDBC driver version 2.0.4 to access my MySQL database from my Java app. If I do "SELECT NOW()", it returns a String object and not a Date object. I tried to call different functions (e.g. "SELECT DATE_ADD(NOW(), INTERVAL 0 SECOND)") in order to have a Date i