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.
2006-02-24 12:00:00 against 2006-02-24
This might be more SQL question sorry about that.
Thanks
-Will
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 India
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
