Sql

SELECT CAST(float_to_convert AS INTEGER) FROM your_table;
-- Or
SELECT float_to_convert::integer FROM your_table;

PREVIOUS	NEXT

Code Example
Sql :: postgres set column based on another column
Sql :: postgresql find duplicates
Sql :: sql column contains special character
Sql :: sql date diff
Sql :: t-sql merge example
Sql :: get sql instance name
Sql :: database disk image is malformed sqlite fix ubuntu
Sql :: sql_calc_found_rows
Sql :: count column of tables psql
Sql :: oracle create table if not exists
Sql :: how to drop a table in mysql
Sql :: mysqldump --skip-lock-tables
Sql :: store select query result in variable sql server
Sql :: select last row mysql
Sql :: select new table sql
Sql :: oracle sql pad left zeros
Sql :: how to insert ip address in mysql using php
Sql :: SELECT exists sql
Sql :: sql drop column
Sql :: find the median in sql
Sql :: excel export from sql using python
Sql :: check table exist postgresql
Sql :: sql datetime format dd/mm/yyyy hh:mm am/pm
Sql :: python sqlite data delete
Sql :: postgresql Create a new role with a username and password
Sql :: mysql version
Sql :: install postgresql 10 centos 7
Sql :: sql query for getting data with join and count
Sql :: truncate all tables
Sql :: mysql multiple order by