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

 

Justin Taylor

Justin's path into design and marketing has been anything but conventional. A random selection of career decisions saw him designing rave flyers, t-shirts and (although refusing to divulge his stage name) he allegedly did a summer stint in Gt Yarmouth as a magician before finally settling on a career in marketing.