Help with mysql str-to-date
mysql, php
Solution
A simple but yet effective typo, it's `%m` and not `m%`. ;)
Problem
I cannot get this to work. I want to use str_to_date to convert a date string. Here is my insert statement. ``` INSERT INTO cars(carno, color, date) VALUES ('1', 'brown', STR_TO_DATE('$date', 'm%/%d/%Y')) ``` Can someone please tell me where I am going wrong? The date in my variable is 12/12/2002 Anyone???