What is the limit of the field type BIGINT in SQL?

sql bigint
ozsenegal picture ozsenegal · Dec 10, 2010 · Viewed 80.1k times · Source

What is the limit of the field type BIGINT in SQL?

is 100000235882380 or 100000466411115 acceptable? (That is ID from facebook)

Answer

Dan Grossman picture Dan Grossman · Dec 10, 2010

Check the manual of the RDBMS you're using. It may not be the same in all systems.

MySQL:
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html

PostgreSQL:
https://www.postgresql.org/docs/10/static/datatype-numeric.html

SQL Server (Transact-SQL):
https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql

DB2:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_biginteger.htm

Related questions

Convert nvarchar to bigint in Sql server 2008

I want insert all rows of a table into another table, and I also want convert a nvarchar field into bigint, but when I use convert(bigint, col1) SQL Server shows an error: Error converting data type nvarchar to bigint …

Read More
How to format bigint field into a date in Postgresql?

I have a table with a field of type bigint. This field store a timestamp. I want to date format the field like this : to_char( bigint_field,'DD/MM/YYYY HH24:MI:SS') I get the following error : ERROR: …

Read More
Arithmetic overflow error when summing an INT, how do I cast it as a BIGINT?

When I try to get the sum of a column from a table I get the error Arithmetic overflow error converting expression to data type int because the resulting number is to big for an INT. So I tried to …

Read More