postgres float to int

Solutions on MaxInterview for postgres float to int by the best coders in the world

showing results for - "postgres float to int"

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

similar questions

postgres cast as currency format convert float to int sql postgres can integer fields be negative postgres extract number from string float postgres postgres convert text to number parsing float to int in mysql postgres integer set default value postgresql cast cast as decimal postgresql psql use query result convert decimal python numpy psycopg2 postgresql convert text to float how to show index type in postgresql postgres cast as decimal

queries leading to this page

postgresql why float 2f float is int float and int postgres add postgres convert float to int ignore float from string and convert to int postgres cast float to int postgresql postgres float to int ignore float and convert to int postgres postgres float to int