Archive for December, 2011

 

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

 

Read More