Skip navigation links

MySQL Forums :: Newbie :: convert string to number


Advanced Search

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 Timmo Henseler 04/28/2010 11:37AM
Re: convert string to number laptop alias 04/28/2010 12:03PM
Re: convert string to number Teunis Middelkoop 04/28/2010 12:32PM
Re: convert string to number Timmo Henseler 04/28/2010 12:55PM
Re: convert string to number Timmo Henseler 04/28/2010 01:01PM
Re: convert string to number laptop alias 04/28/2010 01:29PM
Re: convert string to number Timmo Henseler 04/28/2010 02:24PM


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.