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

24 votes226 views4 answers
How to add column sql
SQL
0 vote304 views1 answer
Python get backup of sql
SQL
0 vote231 views1 answer
Oracle sql date winter time
SQL
0 vote255 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote216 views1 answer
Psql no such file or directory
SQL
5 votes255 views2 answers
Sql number columns
SQL
7 votes246 views1 answer
Oracle pagination query offset
SQL
0 vote258 views1 answer
Pgadmin save data greyed out
SQL
0 vote232 views1 answer
Mysql select where field is a value
SQL
0 vote191 views1 answer
Mysql offset from bottom
SQL