Re: [PHP] mysql DATE_FORMAT() question

nevermind, I see I had a mistake in my mysql statement, I should of been: select DATE_FORMAT(testdate, '%m\-%d\-%Y') as date_column from testtable; please disregard. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] mysql DATE_FORMAT() question

I ran the commands: CREATE TABLE testtable ( testdate DATETIME); INSERT INTO testtable (testdate) VALUES (now()); and then I want to select it but format it to show the date only (not the time, and yes I know I could use DATE instead of DATETIME, but there may be cases where I need to show th