Extract only date from mysql datetime column in mysql

By | April 29, 2014

Problem :

Mysql database has datetime field and i want to get only date. 

Solution :

SELECT CAST(`datetime_field` AS DATE) AS dateonly FROM etc….