Re: Date Formatting
| From: | 1LT John W. Holmes | Date: | Fri, 13 Dec 2002 19:13:15 +0000 |
| Subject: | Re: Date Formatting | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-128192@lists.php.net to get a copy of this message | ||
Use DATE_FORMAT() in your query, or UNIX_TIMESTAMP() to pull it out as a
unix timestamp and use date() in PHP to format it.
Chapter 6, Date and Time Functions in the MySQL Manual has the syntax for
each of the MySQL functions.
---John Holmes...
----- Original Message -----
From: "Clint Tredway" <ctredway@fishermenstudios.com>
To: <php-general@lists.php.net>
Sent: Friday, December 13, 2002 12:55 PM
Subject: [PHP] Date Formatting
How can I format a date coming out of a MySQL? I know how to format today's
date but not a date coming out of MySQL. I have looked through the manual,
but I must be blind because I cannot figure it out.
Thanks,
Clint