Re: timestamp to readabe date and time ?
| From: | Rainer Müller | Date: | Sun, 11 Apr 2004 11:55:16 +0000 |
| Subject: | Re: timestamp to readabe date and time ? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-183121@lists.php.net to get a copy of this message | ||
Damian Brown schrieb:
I need to output a date and time that shows more clearly than just outputting the timestamp what is the correct way to go about it ? I have looked at getdate(), but I haven't fathomed it out yet ! -- www.phpexpert.org/truefaith.htm "True Faith is not just when you believe in God and yourself, it is when others begin to believe in you as well" - Damian John Paul Brown 2004It is from an MySQL database with the field types DATETIME, DATE or TIME? When you can use the mysql function DATE_FORMAT() Example: SELECT *,DATE_FORMAT(mydate,'%d.%m.%y - %H:%i') AS mydate FROM foo (mydate is the name of the column) Rainer