On Wed, Sep 29, 2010 at 3:11 PM, David Mehler dave.meh...@gmail.com wrote:
Hello,
I've got dates stored in a mysql database. The field is of type date
so the value is something like: 2010-09-29 I'm wanting to display
them as in U.S. dates as in month, day, year. I had a function that
did
http://www.w3schools.com/sql/func_date_format.asp
when you do your select, SELECT DATE_FORMAT(`field_name`,'%b %d %Y %h:
%i %p') AS 'field_name'
which would yield you the field field_name:
'Nov 04 2008 11:45 PM'
would be easier to do it there, rather than in your PHP... and you can
change the
2 matches
Mail list logo