Return to Snippet

Revision: 31533
at September 8, 2010 21:57 by flashmac


Initial Code
SELECT DATE_FORMAT(dateColumnName, '%m/%d/%Y %h:%i %p') AS whatever

------------------------ RESULT ------------------------

//Turns MySQL Date from this
2009-12-25 16:25:00 

//TO THIS
Ho Ho Ho, It's Christmas!! (Just kidding)

//TO THIS (HONEST)
25/12/2009 16:25 PM

Initial URL

                                

Initial Description

                                

Initial Title
Display MYSQL date as readable to us humans

Initial Tags
mysql, php, date

Initial Language
MySQL