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
- 7995 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ankal
assuming this value is sal colume i mean sal=123.45; u want to update it with after decimal value.i think The following query try.
update table_name set sal=sal-cast(sal as int));
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / tdguy
Above answers are correct, but data type should be taken
care of.
| Is This Answer Correct ? | 1 Yes | 0 No |
How do you do backup and recovery in teradata?
What are the functions involved in shared information architecture?
what are the uses of fact table and dimension table in banking project?
What is the command in bteq to check for session settings ?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
What is the purpose of indexes?
Can any one please provide me practical example of How to do the performance tuning in Query??
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How can you track login parameters of users in teradata?
What are the uses of client software involved in teradata?
What is partitioned primary index (ppi)?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
Teradata 
