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, 3109🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...