Posted by Jim Moseby on 07/08/05 03:00

Martin Toombs wrote:
> I'm trying to format a date field in PHP which has been stored in a date
> field and can't get it to work.
>
> I've tried date() and date_format() to no avail. It works if I want to
> display today's date, but I want to format the display of the date which
> is coming form the database field.
>
> Unformatted, it looks like 2005-07-02 21:53:00
>
> I want it to read July 2, 2005.
>
> Any help will be appreciated.

select date_format(datefieldname, "%M %e, %Y") from tablename;

JM

[Back to original message]