将m / d / y（01/1/2001示例）字符串存储为DATE

Question

When I try to SELECT CAST('01/1/2001' AS DATE), it always returns NULL (as an example of how I can't get this to work). I'm trying to INSERT data created in this format.

How can I store dates of this format in a DATE column?

Please note that the day never has a prefix 0 while the month does if it is less than 10.

Answer 1

You can use MySQL function STR_TO_DATE() like this:

STR_TO_DATE('01/1/2012',  '%d/%m/%Y')

Of course edit the format according to what you need.