MySQL date format
On a ColdFusion data entry page I capture a date as: mm/dd/yy.
Then insert it to MySql database. The date is screwed up unless a yyyy/mm/dd date is inserted.
My database/sql knowledge is limted. Can anone tell me a simple way of inserting / converting it from mm/dd/yy to yyyy/mm/dd before inserting it to the database.