[thelist] MySQL Convert String To Date

Chris Marsh chris at ecleanuk.com
Tue Jul 22 09:25:23 CDT 2003

Dear all

I have a MySQL database containing a table specifying a field of type
varchar. This field actually contains dates, and I need to perform some
calculations on these dates within a SQL query. The dates are in the
format d[d]/m[m]/yyyy. Can I convert such a string to a date that I can
perform calculations on within SQL using MySQL? I know that the field
should be of type datetime, but I cannot fix this right now.



Chris Marsh

More information about the thelist mailing list