This function converts a number from one measurement system to its equivalent in another measurement system.
Syntax
CONVERT(number,from-unit,to-unit)
Arguments
This function has these arguments:
Argument |
Description |
number |
Numeric value to convert |
from-unit |
Convertible units (see table below) of numeric value to convert |
to-unit |
Convertible units (see table below) of desired result |
Remarks
In this context a measurement system is a set of units for different types of measurements. This function converts a number with one set of units to a number in different set of units.
An error value is returned if the convertible units (from-unit and to-unit) are invalid or are from different categories of unit types (different tables below).
The following tables list the convertible units by their unit type:
Weight and Mass Unit Type |
Convertible Units |
Gram |
"g" |
Slug |
"sg" |
Pound Mass |
"lbm" |
U |
"u" |
Ounce Mass |
"ozm" |
Distance Unit Type |
Convertible Units |
Meter |
"m" |
Statute mile |
"mi" |
Nautical mile |
"Nmi" |
Inch |
"in" |
Foot |
"ft" |
Yard |
"yd" |
Angstrom |
"ang" |
Pica (1/72 in.) |
"Pica" |
Time Unit Type |
Convertible Units |
Year |
"yr" |
Day |
"day" |
Hour |
"hr" |
Minute |
"mn" |
Second |
"sec" |
Pressure Unit Type |
Convertible Units |
Pascal |
"Pa" |
Atmosphere |
"atm" |
mm of Mercury |
"mmHg" |
Force Unit Type |
Convertible Units |
Newton |
"N" |
Dyne |
"dyn" |
Pound force |
"lbf" |
Energy Unit Type |
Convertible Units |
Joule |
"J" |
Erg |
"e" |
Thermodynamic calorie |
"c" |
IT calorie |
"cal" |
Electron volt |
"eV" |
Horsepower-hour |
"Hph" |
Watt-hour |
"Wh" |
Foot-pound |
"flb" |
BTU |
"BTU" |
Power Unit Type |
Convertible Units |
Horsepower |
"HP" |
Watt |
"W" |
Magnetism Unit Type |
Convertible Units |
Tesla |
"T" |
Gauss |
"ga" |
Temperature Unit Type |
Convertible Units |
Degree Celsius |
"C" |
Degree Fahrenheit |
"F" |
Degree Kelvin |
"K" |
Liquid Measure Unit Type |
Convertible Units |
Teaspoon |
"tsp" |
Tablespoon |
"tbs" |
Fluid ounce |
"oz" |
Cup |
"cup" |
U.S. pint |
"pt" |
U.K. pint |
"uk_pt" |
Quart |
"qt" |
Gallon |
"gal" |
Liter |
"l" |
Data Types
Accepts numeric and string data. Returns numeric data.
Examples
CONVERT(68,"F","C")
See Also