Teradata BIGINT data type represents a signed, binary integer value from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. To convert BIGINT to VARCHAR data type, CAST function can be used directly.
CAST BIGINT to VARCHAR
SEL CAST(-9223372036854775808 AS VARCHAR(100))
Result:
-9223372036854775808.
1 -9223372036854775808.
Remove trailing dot
Function TRIM can be used to remove the trailing dot from the above result:
SEL TRIM(trailing '.' from CAST(-9223372036854775808 AS VARCHAR(100)))
Result:
Trim(TRAILING '.' FROM -9223372036854775808.)
1 -9223372036854775808
Use TO\_CHAR function
Alternatively, use TO_CHAR function directly:
SEL TO_CHAR(-9223372036854775808)
Result:
TO\_CHAR(-9223372036854775808.)
1 -9223372036854775808
*Note - there is no trailing dot char when using TO_CHAR function.