Collections:
Converting Character Strings to Numeric Values in MySQL
How To Convert Character Strings to Numeric Values in MySQL?
✍: FYIcenter.com
You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples:
SELECT CAST('4123.45700' AS DECIMAL) FROM DUAL; 4123.46 -- Very poor conversion SELECT CAST('4.12345700e+3' AS DECIMAL) FROM DUAL; 4123.46 -- Very poor conversion SELECT CAST('4123.45700' AS SIGNED INTEGER) FROM DUAL; 4123 SELECT CAST('4.12345700e+3' AS SIGNED INTEGER) FROM DUAL; 4 -- Very poor conversion
⇒ Using IN Conditions in MySQL
⇐ Converting Numeric Values to Character Strings in MySQL
2018-03-28, 1454🔥, 0💬
Popular Posts:
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...