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 vote359 views1 answer
Oracle list proxy users
SQL
9 votes396 views2 answers
Convert data type in sql
SQL
1 vote353 views2 answers
Mysql current user
SQL
0 vote380 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote359 views3 answers
Average salary in sql
SQL
3 votes664 views1 answer
Postgresql cast
SQL
2 votes348 views1 answer
Sql select min value from multiple columns
SQL
5 votes358 views1 answer
Find table from column name in sql
SQL
1 vote355 views1 answer
How to update date add hours in postgresql
SQL
0 vote366 views1 answer
Normalization in database 2nd normal form
SQL