Hello, You can DATE_FORMAT MySQL Command in your SQL Query. For example: select DATE_FORMAT(yourdatetimefield,'%Y-%m-%d') from yourtable -- Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net ""Mike Ryan"" <miker@xxxxxxxxxxxxxx>, haber iletisinde þunlarý yazdý:E5.F4.08934.F21E5D64@xxxxxxxxxxxxxxx >I would like to have my users input the date formate as mm-dd-yyyy mysql > wants the data to come down as yyyy-mm-dd. > > The question I have is how do I convert from the mm-dd-yyyy to yyyy-mm-dd > so > that I can write it out to the database? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php