Andy11548 Posted July 11, 2011 Share Posted July 11, 2011 This is going to sound really nooby, but how the eff do I format a date from the database? Lol. Example: $DBdate = '2011-07-11'; how would I make that: 11/07/2011 Quote Link to comment https://forums.phpfreaks.com/topic/241656-format-date-from-database/ Share on other sites More sharing options...
LeadingWebDev Posted July 11, 2011 Share Posted July 11, 2011 SELECT date_format(dataFIELD, %e/%m/%Y) as datefield FROM `table` WHERE 1=1 Quote Link to comment https://forums.phpfreaks.com/topic/241656-format-date-from-database/#findComment-1241177 Share on other sites More sharing options...
Andy11548 Posted July 11, 2011 Author Share Posted July 11, 2011 Thanks, Andy. Quote Link to comment https://forums.phpfreaks.com/topic/241656-format-date-from-database/#findComment-1241181 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.