Formatting timestamp date in MySQL
| From: | nyon | Date: | Tue, 09 Apr 2002 11:53:18 +0000 |
| Subject: | Formatting timestamp date in MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-92210@lists.php.net to get a copy of this message | ||
Hi,
I need to recall a date data in a MySQL database.
The column is set as "date timestamp(8)".
A sample of date is "20020409"
I use the PHP Date function to format it back to say "9th April 2002".
$date_formated = date($date, 'S M Y' );
However, it's still doesn't appear as formatted.
Anyone mind sharing their code to do this?
Nyon