Mysql CAST(amount as float)

Cast float mysql

SELECT
    integer_column + 0.0 AS float_column

Source: stackoverflow.com

Parsing float to int in mysql

SELECT CONVERT(150, CHAR);

Mysql CAST(amount as float)

mysql> SELECT CAST(4 AS DECIMAL(4,3));
+-------------------------+
| CAST(4 AS DECIMAL(4,3)) |
+-------------------------+
|                   4.000 |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT CAST('4.5s' AS DECIMAL(4,3));
+------------------------------+
| CAST('4.5s' AS DECIMAL(4,3)) |
+------------------------------+
|                        4.500 |
+------------------------------+
1 row in set (0.00 sec)

mysql> SELECT CAST('a4.5s' AS DECIMAL(4,3));
+-------------------------------+
| CAST('a4.5s' AS DECIMAL(4,3)) |
+-------------------------------+
|                         0.000 |
+-------------------------------+
1 row in set, 1 warning (0.00 sec)

Source: stackoverflow.com

Similar codes

57 votes373 views5 answers
How to create a new user in postgresql
SQL
0 vote224 views1 answer
Mysql count unique in group statement
SQL
45 votes254 views5 answers
Grant all privileges mysql
SQL
0 vote256 views2 answers
How to drop mili second in sql
SQL
0 vote227 views3 answers
Find below average salary in sql
SQL
7 votes277 views3 answers
Sql server check if temp table exists
SQL
0 vote226 views1 answer
Oracle running queries sql
SQL
0 vote247 views1 answer
How to generate ids in sql
SQL
0 vote226 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote197 views1 answer
Procedures and functions in pl/sql
SQL