Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Convert Character Strings to Numeric Values
How To Convert Character Strings to Numeric Values? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
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
2007-05-11, 4777👍, 0💬
Popular Posts:
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...
What is normalization? What are different types of normalization? It is set of rules that have been ...
Have you ever worked with Microsoft Application Blocks, if yes then which? Application Blocks are C#...
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In...
How To Control Padding Spaces within a Table Cell? - XHTML 1.0 Tutorials - Understanding Tables and ...