teradata

Teradata Cast BIGINT to String

event 2020-12-27 thumb_up 0 visibility 4,437 comment 0 insights

more_vert

warning Please login first to view stats information.

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.

CAST BIGINT to VARCHAR
Remove trailing dot
Use TO_CHAR function

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.

copyright This page is subject to Site terms.

Teradata Cast BIGINT to String

insights Stats

CAST BIGINT to VARCHAR

Remove trailing dot

Use TO_CHAR function

Log in with external accounts

Teradata Cast BIGINT to String

insights Stats

Table of contents

CAST BIGINT to VARCHAR

Remove trailing dot

Use TO_CHAR function

Log in with external accounts