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

1 vote129 views1 answer
Pagination sql
SQL
-1 vote177 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote213 views1 answer
Trigger stock phpmyadmin
SQL
0 vote187 views1 answer
Is not numeric sql
SQL
1 vote174 views1 answer
Create temporal table in sql
SQL
4 votes164 views1 answer
Select nls_date_format
SQL
9 votes196 views2 answers
Sql server check table exists
SQL
0 vote183 views1 answer
Tsql pad left
SQL
1 vote181 views1 answer
Select count distinct multiple columns sql server
SQL
5 votes160 views2 answers
Add column postgres with default value
SQL