Interested to Buy Any Domain ? << Click Here >> for more details...
write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 7956 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
Explain and compare pros and cons of start schemas?
What is meant by a Clique?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is the purpose of upsert command?
What are the available primary index types in teradata.
What is difference between user and database in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Can you connect multiload from ab initio?
What is the primary index in teradata?
Explain the advantages of partitioned primary index in a query?
Explain the term 'tables' related to relational database management system?
What is TPD?
How do you define Teradata?
Highlight the differences between Primary Key and Primary Index.
