no need for quotes select date_format(contract.length_start, '%m-%d-%Y') as length_start from contract where user_id = 1; bastien > Date: Thu, 3 Jan 2008 08:30:55 -0600> From: awilliam@xxxxxxxxxxxxxxxx> To: php-general@xxxxxxxxxxxxx> Subject: mysql date question> > I have a field in mysql as shown by describe contract;> > | length_start | date | YES | | NULL > | |> > Which stores it in the mysql format of YYYY-MM-DD. However, I need the > output of my select statement to show it in MM-DD-YYYY format. I can > select it to see the date in the field:> > select length_start from contract where user_id = 1;> +--------------+> | length_start |> +--------------+> | 2006-01-12 |> +--------------+> 1 row in set (0.00 sec)> > so then I do my date_format() select statement, but it returns a NULL > value. Why?> > select date_format('contract.length_start', '%m-%d-%Y') as length_start > from contract where user_id = 1;> +--------------+> | length_start |> +--------------+> | NULL |> +--------------+> 1 row in set, 1 warning (0.00 sec)> > -- > PHP General Mailing List (http://www.php.net/)> To unsubscribe, visit: http://www.php.net/unsub.php> _________________________________________________________________ Discover new ways to stay in touch with Windows Live! Visit the City @ Live today! http://getyourliveid.ca/?icid=LIVEIDENCA006