Re: Re: PHP and MySQL date

From: 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

« previous php.general (#172772) next »