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
\n\ncreate view sas_cast_db.some_table as \nselect col1, col2, cast(bigint_var as decimal(18)), col3\nfrom real_db.some_table;\n
\n\n
nVector
posted onEnjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment