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

39 votes338 views4 answers
Select duplicates in sql
SQL
1 vote218 views1 answer
File /etc/init.d/mysql not exists
SQL
6 votes295 views3 answers
How to delete table sqlite
SQL
4 votes278 views4 answers
Print pl sql
SQL
0 vote461 views1 answer
The differnece between to values in sql
SQL
0 vote273 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote272 views1 answer
Utiliser sql ligne de commande
SQL
0 vote269 views1 answer
How to get initials in sql
SQL
0 vote273 views2 answers
Enter into postgresql database,create user and grant Access
SQL
4 votes275 views2 answers
Postgres update single column
SQL