/SQL/Sql float to int

Sql float to int

Convert float to int sql

Better to use CAST INT/CEILING/FLOOR:

SELECT CEILING(1235.53)
SELECT FLOOR(1235.53)
SELECT CAST(1235.53 AS INT)

2

Source: grepper.com

Similar codes

2 votes146 views6 answers
Mysql change timezone
SQL
0 vote155 views1 answer
Mysql changer nom table
SQL
0 vote142 views1 answer
Sql orcale i forgot what my name & password was
SQL
2 votes151 views1 answer
Drop sequence
SQL
0 vote144 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
8 votes141 views3 answers
Connect python to mysql
SQL
1 vote141 views2 answers
T-sql random number for each row
SQL
15 votes319 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote134 views1 answer
How to use query in nosql
SQL
3 votes140 views2 answers
Brew start mysql
SQL

Share