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 vote179 views1 answer
Remove transient options sql wordpress
SQL
13 votes330 views4 answers
Sql joining 3 tables
SQL
0 vote159 views1 answer
Mysql find db contarint
SQL
0 vote168 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote161 views1 answer
Sql trim whitespace
SQL
2 votes169 views1 answer
Q operator in plsql
SQL
1 vote210 views1 answer
Psql search table
SQL
2 votes201 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
4 votes161 views2 answers
Select first and last row mysql
SQL
0 vote184 views1 answer
Pass array parameter to stored procedure c#
SQL