You could consider using DATE_FORMAT() when pulling the date out of the
MySQL Table.
HAve a look in the mysql manpages for the ezxact syntax
Wieger
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?
>
> --
> Thanks,
>
> Matt
> [EMAIL PROTECTED]
> < www.mralston.co.uk />
>
> --
> 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]
--
Wieger Uffink
tel: +31 20 428 6868
fax: +31 20 470 6905
web: http://www.usmedia.nl
--
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]
