I need to convert a value of Double Precision to Bigint with PostgreSQL. How can I do that?
I have tried with to_bigint(myvalue)
but that function didn't exist.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityThere are two ways to typecast in Postgres:
You either do it the SQL standard way:
select cast(3.141593 as bigint);
or you could use the Postgres-specific cast operator: ::
select (3.141593 :: bigint);
You might also want to consider the various rounding functions.