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
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
You are currently viewing a placeholder content from Facebook. To access the actual content, click the button below. Please note that doing so will share data with third-party providers.
More InformationYou are currently viewing a placeholder content from X. To access the actual content, click the button below. Please note that doing so will share data with third-party providers.
More Information