Posted by Tgone on 09/01/06 04:23

Chris Hope wrote:
> Tgone wrote:
>
> > I need to convert a MySQL date "2007-03-08", into "March 8th, 2007".
> > Normally I would use MySQL to accomplish this task but I have to use
> > PHP.
> >
> > Here's my code:
> >
> > echo date("F jS, Y", $row['date']);
> >
> > But this returns "December 31st, 1969". I'm not sure what's going on
> > here. Any ideas?
>
> date() expects a unix timestamp as the parameter and you're passing it a
> string. Convert it to a unix timestamp either in the sql or using php's
> strotime() function like so:
>
> echo date("F jS, Y", strtotime($row['date']));
>
> Note that when using unix timestamps for date and time functions you
> have a limited date range from 1970 to 2038. Ideally it's best to do it
> in the database query rather than in PHP.
>
> In MySQL you would use the DATE_FORMAT() function which can be found on
> the following page of the MySQL manual:
> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Thanks! I tried the code and it works. I appreciate your advice.

• Next in forum: $_SERVER['HTTP_HOST'] weird browser problem
• Prev in forum: Re: Converting MySQL dates
• Thread view: Re: Converting MySQL dates

[Reply to this message]