Re: Date question
| From: | Sumeet | Date: | Fri, 24 Feb 2006 17:37:15 +0000 |
| Subject: | Re: Date question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-231038@lists.php.net to get a copy of this message | ||
William Stokes wrote:
Hello, I have a datetime column in MySQL DB. How can I match to that column from php code if I only have the date information available.use date_format("%Y-%m-%d",'date_column') in the sql http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html -- Sumeet Shroff http://www.prateeksha.com Web Design and Ecommerce Development, Mumbai India2006-02-24 12:00:00 against 2006-02-24This might be more SQL question sorry about that. Thanks -Will