Summary
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