write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 6670 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
How many tables can you join in v2r5?
How to eliminate product joins in a teradata sql query?
Explain the parallel data extension in teradata?
What are the steps involved after the disk manager passes the request?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is the use of virtual processor connectivity in teradata?
How to select first n records in teradata?
What do you mean by parsing?
What is the command in bteq to check for session settings ?
Differentiate primary key and partition key?
What do high confidence, low confidence and no confidence mean in explain plan?
How do you set the session mode parameters in bteq?
Explain the most common data types used in teradata?
How is MLOAD Client System restarted after execution?
What is teradata?
