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

0 vote305 views1 answer
How to reset the database value in SQL server
SQL
0 vote287 views1 answer
Postgresql regular expression special characters
SQL
22 votes289 views4 answers
Tsql rename table
SQL
10 votes300 views6 answers
Mysql delete duplicates
SQL
0 vote323 views1 answer
SQL Cut part string
SQL
1 vote286 views1 answer
Sql server update column based on another table
SQL
2 votes302 views1 answer
Oracle apex list connected users
SQL
1 vote277 views1 answer
How to print longest name in sql
SQL
-1 vote316 views1 answer
Pl sql drop trigger
SQL
0 vote322 views1 answer
Mysql record group by created date count
SQL