21 August 2018        Add to Favorites   Report

How to cast a bigint into decimal in Teradata

For example, The SAS reporting tool chokes on BIGINT and requires that we cast variables into a integer or decimal before returning them to SAS. So we can create a temporary view to do the type casting

create view sas_cast_db.some_table as 
select col1, col2, cast(bigint_var as decimal(18)), col3
from real_db.some_table;




Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied