If I'm not mistaken you should use the dateformat function (of the top of my head)
Jack -----Original Message----- From: Shaun [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 1:54 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] 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
