ldoozer Posted February 10, 2008 Share Posted February 10, 2008 I have a date field in my mysql database that looks like this : 2008-02-10. I want to display the date on my page like this: 10th February 2008. What is the best way to do this? Thanks Steve Quote Link to comment https://forums.phpfreaks.com/topic/90349-date-format/ Share on other sites More sharing options...
AndyB Posted February 10, 2008 Share Posted February 10, 2008 http://ca.php.net/manual/en/function.date.php explains how to generate any kind of displayed date format you want. Quote Link to comment https://forums.phpfreaks.com/topic/90349-date-format/#findComment-463247 Share on other sites More sharing options...
PFMaBiSmAd Posted February 10, 2008 Share Posted February 10, 2008 Or if you want to do it directly in your SELECT query - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format Quote Link to comment https://forums.phpfreaks.com/topic/90349-date-format/#findComment-463252 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.