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

4 votes381 views1 answer
How to drop a database in sql server when it is in use
SQL
6 votes342 views1 answer
Oracle rank() over (partition)
SQL
4 votes354 views1 answer
Phone number sql
SQL
0 vote356 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
7 votes378 views2 answers
Phpmyadmin change password
SQL
5 votes390 views2 answers
Oracle list columns
SQL
1 vote453 views2 answers
Begin transaction sql
SQL
0 vote338 views1 answer
Drop all tables in azure sql database
SQL
3 votes333 views1 answer
Oracle limit user tablespace
SQL
0 vote350 views1 answer
Initcap in mysql
SQL