Converts a numeric value to a different unit of measure.
Sample Usage
CONVERT(2000,"m","km")
CONVERT(68,"F","C")
Syntax
CONVERT(number, from_unit, to_unit)
- number - The numeric value to convert.
- from_unit - The unit before conversion.
- to_unit - The unit after conversion.
Examples
CONVERT(2000,"m","km") converts 2000 meters into kilometers, and returns the value 2.
CONVERT(68,"F","C") converts 68 degrees Fahrenheit to Celsius, and returns the value 20.
Notes
- If the unit does not exist, CONVERT returns the #N/A error value.
- If the units are in different groups, CONVERT returns the #N/A error value.
- Unit names and prefixes are case-sensitive.
- The following list outlines the units by category:
- Weight - u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton
- Distance - ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec
- Time - sec, min, hr, day, yr
- Pressure - Pa, mmHg, Torr, psi, atm
- Force - dyn, pond, N, lbf
- Energy - eV, e, J, flb, c, cal, BTU, Wh, HPh
- Power - W, PS, HP
- Magnetism - ga, T
- Temperature - C, F, K, Rank, Reau
- Volume - ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3
- Area - ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2
- Information - bit, byte
- Speed - m/hr, mph, kn, admkn, m/s