Mysql date only from a date time field.

If your date in mysql is in a datetime field  :

2012-04-29 14:07:51

and you just want the date part , not the time and also in european format use this:

select DATE_FORMAT( DATE( field) , ‘%D %M, %Y’) from X

 

Adam Skinner

Web developer who takes a keen interest in FOSS and other technical subjects. Currently learning laravel