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