General MySQL Oracle SQL Server

Converting Character Strings to Numeric Values in MySQL

Q

How To Convert Character Strings to Numeric Values in MySQL?

✍: FYIcenter.com

A

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

⇑ Introduction to SQL Basics in MySQL

⇑⇑ MySQL Database Tutorials

2018-03-28, 3735🔥, 0💬

General MySQL Oracle SQL Server