Thanks Papi,
That works fine.
Matt
[EMAIL PROTECTED]
< www.mralston.co.uk />
Pavel Jartsev <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Matthew Ralston wrote:
> >
> > I've got a date stored in a MySQL database in a "DATE" field, so it is
> > stored as "2001-05-21". How do I convert that into a more friendly date
like
> > "21 May 2001" or even "21st May 2001" for display on a web page?
> >
> > I've tried
> >
> > print date("jS F Y", $dbtable[date]);
> >
> > but I always get "1st January 1970" because I don't know how to convert
the
> > MySQL date into a PHP timestamp.
> >
> > Can someone tell me how to do it please?
> >
>
> Maybe it's not very nice, but it works:
> <?
> list($y,$m,$d) = explode('-', $dbtable['date']);
> print date("jS F Y", mktime(0, 0, 0, $m, $d, $y));
> ?>
>
>
> Hope this helps.
>
> --
> Pavel a.k.a. Papi
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
