If I'm not mistaken you should use the dateformat function (of the top of my head) Jack -----Original Message----- From: Shaun [mailto:shaun@mania.plus.com] Sent: Tuesday, September 23, 2003 1:54 PM To: php-db@lists.php.net Subject: DATETIME Field Query Hi, I had a DATE field in my table which I have now changed to DATETIME. When querying this field, how can I retrieve say the date part, or the minutes part for example from the table? At the moment I am just retrieving the whole field... Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
