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 t
On Wed, Sep 29, 2010 at 3:11 PM, David Mehler 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 this, now it is no
2 matches
Mail list logo
