How can I convert from Double Precision to Bigint with PostgreSQL?

Question

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.

eevar · Accepted Answer · 2013-09-21 09:02:33Z

50

There 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.

user1822

answered Jun 22, 2011 at 9:34

eevar

7126 silver badges6 bronze badges

2

@eevar Just a note from the docs, the rounding functions return type is "same as input," so if the type is important, casts are required.
– shortstuffsushi
Aug 19, 2015 at 21:34
1

Looks like CAST actually does rounding
– Andrew Wolfe
Mar 17, 2016 at 19:34
1

Is there a doc which function is applied when SELECT 4.7::int?
– Eugen Konkov
Mar 6, 2020 at 12:09

Add a comment |

1 Answer 1