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")
Version Available
This function is available in product version 2.0 or later.
See Also
OCT2BIN | HEX2DEC | DEC2OCT | Engineering
Functions
