when i save float data value 11.22 but this see in table
11.220000004758456 type ? how to save only two decimal point.
Answer / guest
if u put 11.22 in a variable x, try this :
x=11.22;
printf("%2.2f",x);
2.2f specifies that ,it will print exactly 2 digits to the
left of decimal point and 2 digits to the right of the decimal
point.You can use any number according to ur requirement ,like
(%x.yf).
| Is This Answer Correct ? | 4 Yes | 0 No |
How many types of internal joins are there in SQL Server?
What are row constructors?
Is the company liable to deduct professional tax of directors?
What is the meaning of lock escalation and why/how to stop this?
When do you get "getwmicomexception"?
I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.
What severity level errors are managed in TRY-CATCH block?
what is meant by write off and write on in sap?
5 Answers Reliance Communications, Wipro,
today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql
What are the required/mandatory parameters that have to be passed with RAISEERROR statement?
I have table name'temp' in that I wanted to add some partial data for a particular column name 'policyno' where data is existing in that column. Ex.Policyno like 'R-KT-SK- EA-134526' like 100 records. In that 100 records some policynos are just like 134527 I mean with out prefix like'R-KT-SK-EA-' now I wanted add this prefix as 'R-KT-SK- EA-134527' for some 50 records. How can I add partial data?
when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.