Collections:
Converting Numeric Values to Character Strings in MySQL
How To Convert Numeric Values to Character Strings in MySQL?
✍: FYIcenter.com
You can convert numeric values to character strings by using the CAST(value AS CHAR) function as shown in the following examples:
SELECT CAST(4123.45700 AS CHAR) FROM DUAL; 4123.45700 -- How to get rid of the last 2 '0's? SELECT CAST(4.12345700E+3 AS CHAR) FROM DUAL; 4123.457 SELECT CAST(1/3 AS CHAR); 0.3333 -- Very poor conversion
⇒ Converting Character Strings to Numeric Values in MySQL
⇐ Expressions with NULL Values in MySQL
2018-03-28, 2958🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...