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 vote363 views1 answer
Add new column in sql with foreign key
SQL
0 vote314 views1 answer
Why mysql is used?
SQL
1 vote311 views1 answer
Import in mysql without a software
SQL
1 vote328 views1 answer
Psql lst trigger
SQL
1 vote313 views1 answer
Check message id sql server
SQL
1 vote328 views3 answers
SELECT * FROM
SQL
0 vote321 views1 answer
Mysql update from n to 100
SQL
2 votes309 views1 answer
Oracle cpu per session
SQL
0 vote332 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote271 views1 answer
Unique vs distinct sql
SQL