Problems handling dates using MySQL backend

[StargazeR82]

I'm using MX to develop a web interface for a MySQL backend. MySQL wants dates in the format yyyy/mm/dd.
When I show an update page for an order, it shows me the date in the format mm/dd/yy. If you update the order and just leave the date the same...it won't take the date b/c it's no longer in the proper format...how should i handle this? Any help is appreciated.

 

[lebisol]

"sometimes"...u can find info with those who made it

http://www.mysql.com/doc/en/Date_and_time_functions.html.

or google:

http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=MySQL+change+date+format

but I have no experience in PHP or mySQL
all the best!