How To Convert Numeric Values to Character Strings?
Submitted by: AdministratorYou 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online MySQL Programming Job Interview Questions And Answers
Top MySQL Programming Questions
| ☺ | What Is TIMESTAMP in MySQL? |
| ☺ | How To Use Regular Expression in Pattern Match Conditions? |
| ☺ | How To Write Date and Time Literals? |
| ☺ | How To Use CASE Expression? |
| ☺ | How To Decrement Dates by 1 in MySQL? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
