[thelist] MySQL Convert String To Date

[Chris Marsh]

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.

TIA

Regards

Chris Marsh