Re: Easy Date & MySQL Question...
| From: | Jesper Brunholm | Date: | Wed, 26 Jun 2002 08:33:19 +0000 |
| Subject: | Re: Easy Date & MySQL Question... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-103924@lists.php.net to get a copy of this message | ||
John Holmes wrote:
Yes? - but you did not try searching with the keyword "date" or how? Even a search in Google with "php date" returns the manual's page with date() as first response... BUT the mysql-manual: <http://www.mysql.com/doc/D/a/Date_and_time_functions.html> is often a good thing to know when matters concern queryes...I have searched the php.net and don't know where to look for the code
Do the formatting in your query. Use the MySQL function DATE_FORMAT(). Look it up in the MySQL manual, chapter 6: Date and Time Functions... ---John Holmes...Regards Jesper Brunholm -- Phønix - Danish folk music from young musicians - http://www.phonixfolk.dk