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