Re: Casting Varchar to a date

[Barry Galbraith]

Does this help?

mysql> select str_to_date('12/06/2013','%d/%m/%Y');
+--------------------------------------+
| str_to_date('12/06/2013','%d/%m/%Y') |
+--------------------------------------+
| 2013-06-12                           |
+--------------------------------------+
1 row in set (0.05 sec)

And, you really need to store your dates a field of type DATE.

That will allow you to do "date arithmetic" on your values.

Good luck,
Barry.