What is the method for assigning a value to a bigint type in SQL?

1 year ago

Liam

1 minute

In SQL, you can convert other data types to BIGINT using the CAST or CONVERT functions. For example:

SELECT CAST(column_name AS BIGINT) AS new_column_name
FROM table_name;

SELECT CONVERT(BIGINT, column_name) AS new_column_name
FROM table_name;

In this way, the data of a column can be converted to the BIGINT type and assigned to a new column.