CONVERT(Number,Fromunit,Tounit)
is the value in
to change.
is the units for the value.
is the units for the result.
Description
- This function converts one unit system to another unit system.
- Example:To change the length in kilometer unit to standard unit meter.
and
will accept any units which we need to give in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle " "}
(double quotes).
This function show the result as Error:
- when the input value are incorrect
- when the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Fromunit}
and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Tounit}
does not exist
- when the units are in not same groups.
Unit names and indications are case-sensitive.
| Weight/Mass
|
Fromunit or Tounit
|
| Gram
|
"g"
|
| Kilo gram
|
"kg"
|
| Slug
|
"sg"
|
| Pound mass
|
"lbm"
|
| U(atomic mass unit)
|
"u"
|
| Ounce mass
|
"ozm"
|
| Distance
|
Fromunit or Tounit
|
| Meter
|
"m"
|
| Kilometer
|
"km"
|
| Statute mile
|
"mi"
|
| Nautical mile
|
"Nmi"
|
| Inch
|
"in"
|
| yard
|
"yd"
|
| Foot
|
"ft"
|
| Angstrom
|
"ang"
|
| Pica(1/72 in.)
|
"Pica"
|
| Time
|
Fromunit or Tounit
|
| Year
|
"yr"
|
| Day
|
"day"
|
| Hour
|
"hr"
|
| Minute
|
"mn"
|
| Second
|
"sec"
|
| Pressure
|
Fromunit or Tounit
|
| Pascal
|
"Pa"
|
| Atmosphere
|
"atm"
|
| mm of Mercury
|
"mmHg"
|
| Force
|
Fromunit or Tounit
|
| Newton
|
"N"
|
| Dyne
|
"dyn"
|
| Pound Force
|
"lbf"
|
| Energy
|
Fromunit or Tounit
|
| Joule
|
"J"
|
| Erg
|
"e"
|
| IT calorie
|
"cal"
|
| Thermodynamic calorie
|
"c"
|
| BTU
|
"BTU"
|
| Electron volt
|
"eV"
|
| Foot pound
|
"flb"
|
| Horsepower hour
|
"HPh"
|
| Watt-hour
|
"Wh"
|
| Kilocalorie
|
"kcal"
|
| Power
|
Fromunit or Tounit
|
| Horse power
|
"HP"
|
| Watt
|
"W"
|
| Magnetism
|
Fromunit or Tounit
|
| Gauss
|
"ga"
|
| Tesla
|
"T"
|
| Temperature
|
Fromunit or Tounit
|
| Kelvin
|
"K"
|
| Degree Celsius
|
"C"
|
| Degree Fahrenheit
|
"F"
|
| Liquid Measure
|
Fromunit or Tounit
|
| Liter
|
"l"
|
| Milliliter
|
"ml"
|
| Gallon
|
"gal"
|
| Quart
|
"qt"
|
| U.K.pint
|
"uk_pt"
|
| U.S.pint
|
"pt"
|
| Cup
|
"cup"
|
| Fluid ounce
|
"oz"
|
| Teaspoon
|
"tsp"
|
| Tablespoon
|
"tbs"
|
For Example, =CONVERT(1.50, "lbm", "kg") is 0.6804
ZOS Section
- The syntax is to calculate CONVERT in ZOS is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle CONVERT(Number,Fromunit,Tounit)}
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Number}
is the value in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Fromunit}
to change.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Fromunit}
is the units for the value.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Tounit}
is the units for the result.
- For e.g.,CONVERT(10.5..12.5..0.25,"in","ft")
Examples
| Equation
|
Number
|
Fromunit
|
Tounit
|
Result
|
| CONVERT(10,"ozm","sg")
|
10
|
ozm
|
sg
|
0.019425668878
|
| CONVERT(30,"lbm","kg")
|
30
|
lbm
|
kg
|
13.60776929
|
| CONVERT(0.5,"mi","m")
|
0.5
|
mi
|
m
|
804.6077
|
| CONVERT(0.002,"km","Nmi")
|
0.002
|
km
|
Nmi
|
0.001079
|
| CONVERT(5,"ft","in")
|
5
|
ft
|
in
|
60
|
| CONVERT(7,"yd","ang")
|
7
|
yd
|
ang
|
64007999999.9
|
| CONVERT(5,"yd","Pica")
|
5
|
yd
|
Pica
|
12959.99
|
| CONVERT(15,"Pa","mmHg")
|
15
|
Pa
|
mmHg
|
0.112509
|
| CONVERT(4, "yr","day")
|
4
|
yr
|
day
|
1461
|
| CONVERT(1.5,"mn","sec")
|
1.5
|
mn
|
sec
|
90
|
| CONVERT(15,"lbf","N")
|
15
|
lbf
|
N
|
66.72333
|
| CONVERT(10,"BTU","J")
|
10
|
BTU
|
J
|
10550.581
|
| CONVERT(15,"W","HP")
|
15
|
W
|
HP
|
0.020115301
|
| CONVERT(45,"T","ga")
|
45
|
T
|
ga
|
450000
|
| CONVERT(90,"F","K")
|
90
|
F
|
K
|
305.3722222
|
| CONVERT(100,"oz","cup")
|
100
|
oz
|
cup
|
12.5
|
| CONVERT(25,"pt","qt")
|
25
|
pt
|
qt
|
62.5
|
See also
References
Convert Units