RE: [PHP] Converting datestamp to text?
| From: | David Freeman | Date: | Sun, 11 Aug 2002 00:55:33 +0000 |
| Subject: | RE: [PHP] Converting datestamp to text? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111990@lists.php.net to get a copy of this message | ||
> In my MySQL db I have a date-field on every entry looking like this :
> 2002-08-10
> When presented on a PHP page, I want it converted to
> "Saturday, Augusth
> 10th, 2002".
>
> How do I achieve that? I've been playing around with the
> date-command and
> strtotime-command but haven't achieved it.
Do it in your mysql query instead. Have a look at DATE_FORMAT() in your
friendly local neighbourhood mysql manual. Chapter 6.3.4 or
thereabouts.
CYA, Dave