mysql - Format values on entire column SQL -

I have a column that has the value of the format "01-01-2012" and I have to change it to "01.01" . 2012 ". I have to do this for all the posts of that colon.

Can you please suggest doing so? I need a general SQL statement.

Thank you

Try using it:

  update tablename set column_name = REPLACE (column_name, '-', '.')