Re: Re: PHP and MySQL date
| From: | John W. Holmes | Date: | Tue, 16 Dec 2003 02:54:51 +0000 |
| Subject: | Re: Re: PHP and MySQL date | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-172772@lists.php.net to get a copy of this message | ||
Cesar Aracena wrote:
I tried what both of you told me and I found very easy to use the datetime value under MySQL and then fetch it using strtotime() as fireball at sizzling dot com recommended at the "User Contributed Notes" of php.net's function.date.php page rather than using mktime() which can output incorrect dates.You can also use the MySQL function DATE_FORMAT() to format the MySQL timestamp to your liking. It is very similar to the PHP date() function. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com