Show only two digit after decimal
Use DecimalFormat.
DecimalFormat is a concrete subclass of NumberFormat that formats
decimal numbers. It has a variety of features designed to make it
possible to parse and format numbers in any locale, including support
for Western, Arabic, and Indic digits. It also supports different
kinds of numbers, including integers (123), fixed-point numbers
(123.4), scientific notation (1.23E4), percentages (12%), and currency
amounts ($123). All of these can be localized.
Code snippet -
double i2=i/60000;
tv.setText(new DecimalFormat("##.##").format(i2));
Output -
5.81
How to display two digits after decimal point in SQL Server
select cast(your_float_column as decimal(10,2))
from your_table
decimal(10,2)
means you can have a decimal number with a maximal total precision of 10 digits. 2 of them after the decimal point and 8 before.
The biggest possible number would be 99999999.99
Need only 2 digits after decimal point
Very simple. Try this
public double UptoTwoDecimalPoints(double num)
{
var totalCost = Convert.ToDouble(String.Format("{0:0.00}", num));
return totalCost;
}
Hot to show only two digits after decimal using double
It looks like the double assigned in line
prezzoTotale = String.valueOf(String.format ("%.2f", (calcoloPrezzoTotale())));
contains a comma (,
, i.e. 1,2
) due to the locale settings. So take care that parsing happens with the same locale.
Class NumberFormat
helps you out:
NumberFormat format = NumberFormat.getInstance(Locale.FRANCE);
Number number = format.parse("1,234");
double d = number.doubleValue();
Looking at your code it could be Locale.ITALY
as well ;) check the full Locale list here.
p.s.: String.format()
uses Locale.getDefault();
as per documentation. Use logcat to check its value, if you are not sure about the system setting or use the alternative method public static String format(Locale l, String format, Object... args)
which allows you to specify the Locale.
How to Show only two Digits after Decimal
Rakesh use this link:
Show only two digit after decimal
i=348842.
double i2=i/60000;
DecimalFormat dtime = new DecimalFormat("#.##");
i2= Double.valueOf(dtime.format(time));
v.setText(String.valueOf(i2));
How to display two digits after decimal every time using C#?
try
double num=17.2;
string str=num.toString("0.00");
or this one.
double num=17.2;
string str=num.toString("N2");
Leave only two decimal places after the dot
string.Format
is your friend.
String.Format("{0:0.00}", 123.4567); // "123.46"
how to display two digits after decimal point in a calculated column in SQL?
You could use TRUNCATE
TRUNCATE(X,D)
Returns the number X, truncated to D decimal places. If D is 0, the
result has no decimal point or fractional part. D can be negative to
cause D digits left of the decimal point of the value X to become
zero.
Something like this:
select *,
TRUNCATE((TotalDeaths/TotalCases)*100,2) as PercentDeath,
TRUNCATE((TotalDeaths/population)*100,2) as DeathPercentPopulation
from ( select location,
population,
sum(newcases) as TotalCases,
sum(newdeaths) as TotalDeaths
from deaths
where continent is not null
group by location
) as newtable
order by DeathPercentPopulation desc
Or you could use ROUND
function.
The ROUND() function in MySQL is used to round a number to a specified
number of decimal places. If no specified number of decimal places is
provided for round off, it rounds off the number to the nearest
integer.Syntax :
ROUND(X, D) Parameter : This method accepts two parameters in the
syntax, as mentioned above and described below –X : The number which to be rounded. D : Number of decimal places up to
which the given number is to be rounded. It is optional. If not given
it round off the number to the closest integer. If it is negative,
then the number is rounded to the left side of the decimal point.
select *,
ROUND((TotalDeaths/TotalCases)*100,2) as PercentDeath,
ROUND((TotalDeaths/population)*100,2) as DeathPercentPopulation
from ( select location,
population,
sum(newcases) as TotalCases,
sum(newdeaths) as TotalDeaths
from deaths
where continent is not null
group by location
) as newtable
order by DeathPercentPopulation desc
Related Topics
Turning Off Hibernate Logging Console Output
Listening for Input Without Focus in Java
Private Final Static Attribute VS Private Final Attribute
Why Hypot() Function Is So Slow
Difference Between Getexternalfilesdir and Getexternalstoragedirectory()
Universal Way to Write to External Sd Card on Android
What Is Difference Between @+Id/Android:List and @+Id/List
Android - Activity Constructor VS Oncreate
How to Parse JSON from a Java Httpresponse
Dx Bad Class File Magic (Cafebabe) or Version (0033.0000) with Adk14
In Java, Are Enum Types Inside a Class Static
Regex Look-Behind Without Obvious Maximum Length in Java
Getting Java Gui to Open a Webpage in Web Browser
Android: Pass Data(Extras) to a Fragment
How to Give Images Rounded Corners in Android