waverider303 Posted September 2, 2009 Share Posted September 2, 2009 I have a row in my database called date which has a data type of "datetime" (YYYY-MM-DD HH-MM-SS) I want to retrieve this and convert it into something like: "June 4th, 2009". So how would I go about taking: 2009-06-04 15:05:55 converting it into -> June 4th, 2009? Link to comment https://forums.phpfreaks.com/topic/172882-converting-sql-datetime-field-to-something-like-june-4th-2009/ Share on other sites More sharing options...
rhodesa Posted September 2, 2009 Share Posted September 2, 2009 SELECT DATE_FORMAT(`date`,'%M %D, %Y') Link to comment https://forums.phpfreaks.com/topic/172882-converting-sql-datetime-field-to-something-like-june-4th-2009/#findComment-911163 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.