MySQL Forums
Forum List  »  Newbie

Re: how to load non english numbers + date-format ?
Posted by: laptop alias
Date: April 28, 2011 05:46AM

SELECT REPLACE(REPLACE('123.45,67','.',''),',','.')a;
+----------+
| a        |
+----------+
| 12345.67 |
+----------+

?

Maybe back up your data before trying this one!

Options: ReplyQuote


Subject
Written By
Posted
Re: how to load non english numbers + date-format ?
April 28, 2011 05:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.