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

15 votes352 views4 answers
Export mysql db using command line
SQL
0 vote373 views1 answer
Sql express database size limit
SQL
0 vote319 views1 answer
Sql query for getting data with join and count
SQL
4 votes357 views1 answer
Postgresql list sequences
SQL
0 vote329 views1 answer
Power query case when
SQL
0 vote322 views1 answer
Back up stored procedures mysql
SQL
5 votes363 views4 answers
Start postgres server
SQL
1 vote362 views1 answer
Customer using hdfc bank sql query
SQL
4 votes336 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote344 views1 answer
Set a default value for a column in sqlite
SQL