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, 2939🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...