MySQL Forums
Forum List  »  Newbie

convert string to number
Posted by: Timmo Henseler
Date: April 28, 2010 11:37AM

I am starting with mysql and want to convert a string like 12.567,98 (dutch format) to a number (decimal format) in an INSERT statement. I did the same with a date using str_to_date but I can't find a similar function for numbers. As far as I can see convert or cast are either not suitable in an insert statement or do not allow to specify the number format (e.g. ##.###,##).

Apparently not a very common question because cannot find anything on the subject in this forum nor in google.

thanks for bringing me back to sanity.

Options: ReplyQuote


Subject
Written By
Posted
convert string to number
April 28, 2010 11:37AM


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.