write a query following data. 123.45 is input.write a query after decimal (ex:.

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

Question Posted / kattarvr

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

Answers were Sorted based on User's Feedback

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into datab..

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

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into datab..

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

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into datab..

Answer / tdguy

Above answers are correct, but data type should be taken
care of.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer