Assuming the column type to be decimal type and the same table to be update

write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?

Question Posted / yuvaevergreen

3 Answers
7812 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / yuvaevergreen

Assuming the column type to be decimal type and the same table to be updated, the string function can be used.
update dbname.tbname
set salary=
substr(cast (salary as char(10)),index(cast (salary as char(10)),'.'))
>>>salary is of type decimal..

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is primary index and secondary index?

973

Explain the term 'database' related to relational database management system?

929

Explain fallback in teradata?

984

Why does varchar occupy 2 extra bytes?

1105

How to find duplicates in a table?

1134

What is the difference between teradata and oracle?

955

What is meant by a Virtual Disk?

1045

Differentiate primary key and partition key?

934

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

957

Can we collect statistics on table level?

987

Describe primary index in teradata?

957

What is the purpose of upsert command?

1078

Explain the term 'columns' related to relational database management system?

988

Explain teradata architecture?

1031

Explain the types of join supports by teradata?

935