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

0 vote176 views1 answer
Sql server python connection
SQL
14 votes186 views3 answers
Delete all records from table except sql
SQL
1 vote198 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
13 votes180 views3 answers
Sql online code
SQL
3 votes196 views2 answers
Postgresql select all column names
SQL
0 vote184 views1 answer
Wordpress sql change site url
SQL
4 votes200 views2 answers
Mysql alter table set column unique
SQL
0 vote165 views1 answer
Separator mysql
SQL
0 vote186 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote202 views1 answer
Mysql where in maintain order
SQL