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

2 votes205 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
2 votes168 views1 answer
Mysql time ago difference
SQL
0 vote172 views1 answer
Oracle create table auto generated primary key
SQL
1 vote165 views1 answer
Temp table vs variable table in sql server
SQL
1 vote203 views1 answer
Oracle show execution plan
SQL
0 vote201 views1 answer
Sql int vs integer
SQL
5 votes166 views2 answers
To date oracle
SQL
0 vote168 views1 answer
Sql query interview questions githu
SQL
21 votes139 views7 answers
Table drop if exist sql server
SQL
0 vote171 views2 answers
Plsql regex match whole word
SQL