CONVERTSPEED

Updated 2024-02-13 19:18:31.783000

Syntax

SELECT [westclintech].[wct].[CONVERTSPEED] (
  <@Speed, float,>
 ,<@From_scale, nvarchar(4000),>
 ,<@To_scale, nvarchar(4000),>)

Description

Use the scalar function CONVERTSPEED to convert to and from feet per hour, feet per minute, feet per second, inches per second, kilometers per hour, knots, miles per hour, miles per minute, miles per second, meters per second, meters per minute or meters per hour.

Arguments

@From_scale

is the description of the units @Speed is being converted from. @From_scale must be a valid value as specified in area unit representations. @From_scale must be of a data type that is implicitly convertible to varchar.

@Speed

is any real number. @Speed is an expression of type float or of a type that can be implicitly converted to float.

@To_scale

is the description of the units @Speed is being converted to. @To_scale must be a valid value as specified in area unit representations. @To_scale must be of a data type that is implicitly convertible to varchar.

Return Type

float

Remarks

· Speed unit representations:

{"columns":[{"field":"feet per hour","width":181},{"field":"ft/h, feet per hour, foot per hour, fph, ft·h","width":457}],"rows":[{"feet per hour":"feet per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"ft/min, feet per minute, foot per minute, fpm, ft·m"},{"feet per hour":"feet per second","ft/h, feet per hour, foot per hour, fph, ft·h":"ft/s, feet per second, foot per second, fps, ft·s"},{"feet per hour":"inches per second","ft/h, feet per hour, foot per hour, fph, ft·h":"in/s, inches per second, inch per second, ips, in·s"},{"feet per hour":"kilometers per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"km/h, kilometers per hour, kilometer per hour, kph, km·h"},{"feet per hour":"knots","ft/h, feet per hour, foot per hour, fph, ft·h":"knot, knots"},{"feet per hour":"miles per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"mi/h, miles per hour, mile per hour, mph, mi·h"},{"feet per hour":"miles per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"mi/min, miles per minute, mile per minute, mpm, mi·m"},{"feet per hour":"miles per second","ft/h, feet per hour, foot per hour, fph, ft·h":"mi/s, miles per second, mile per second, mi·s"},{"feet per hour":"meters per second","ft/h, feet per hour, foot per hour, fph, ft·h":"m/s, meters per second, meter per second, mps, m·s"},{"feet per hour":"decimeters per second","ft/h, feet per hour, foot per hour, fph, ft·h":"dm/s, decimeters per second, decimeter per second, dmps, dm·s"},{"feet per hour":"centimeters per second","ft/h, feet per hour, foot per hour, fph, ft·h":"cm/s, centimeters per second, centimeter per second, cmps, cm·s"},{"feet per hour":"millimeters per second","ft/h, feet per hour, foot per hour, fph, ft·h":"mm/s, millimeters per second, millimeter per second, mmps, mm·s"},{"feet per hour":"microns per second","ft/h, feet per hour, foot per hour, fph, ft·h":"µm/s, microns per second, micron per second, µmps, µm·s"},{"feet per hour":"nanometers per second","ft/h, feet per hour, foot per hour, fph, ft·h":"nm/s, nanometers per second, nanometer per second, nmps, nm·s"},{"feet per hour":"picometers per second","ft/h, feet per hour, foot per hour, fph, ft·h":"pm/s, picometers per second, picometer per second, pmps, pm·s"},{"feet per hour":"femtometers per second","ft/h, feet per hour, foot per hour, fph, ft·h":"fm/s, femtometers per second, femtometer per second, fmps, fm·s"},{"feet per hour":"attometers per second","ft/h, feet per hour, foot per hour, fph, ft·h":"am/s, attometers per second, attometer per second, amps, am·s"},{"feet per hour":"zeptometers per second","ft/h, feet per hour, foot per hour, fph, ft·h":"zm/s, zeptometers per second, zeptometer per second, zmps, zm·s"},{"feet per hour":"yoctometers per second","ft/h, feet per hour, foot per hour, fph, ft·h":"ym/s, yoctometers per second, yoctometer per second, ymps, ym·s"},{"feet per hour":"decameters per second","ft/h, feet per hour, foot per hour, fph, ft·h":"dam/s, decameters per second, decameter per second, damps, dam·s"},{"feet per hour":"hectometers per second","ft/h, feet per hour, foot per hour, fph, ft·h":"hm/s, hectometers per second, hectometer per second, hmps, hm·s"},{"feet per hour":"kilometers per second","ft/h, feet per hour, foot per hour, fph, ft·h":"km/s, kilometers per second, kilometer per second, kmps, km·s"},{"feet per hour":"meters per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"m/min, meters per minute, meter per minute, m·min"},{"feet per hour":"decimeters per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"dm/min, decimeters per minute, decimeter per minute, dmpm, dm·min"},{"feet per hour":"centimeters per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"cm/min, centimeters per minute, centimeter per minute, cmpm, cm·min"},{"feet per hour":"millimeters per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"mm/min, millimeters per minute, millimeter per minute, mmpm, mm·min"},{"feet per hour":"microns per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"µm/min, microns per minute, micron per minute, µmpm, µm·min"},{"feet per hour":"nanometers per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"nm/min, nanometers per minute, nanometer per minute, nmpm, nm·min"},{"feet per hour":"picometers per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"pm/min, picometers per minute, picometer per minute, pmpm, pm·min"},{"feet per hour":"femtometers per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"fm/min, femtometers per minute, femtometer per minute, fmpm, fm·min"},{"feet per hour":"attometers per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"am/min, attometers per minute, attometer per minute, ampm, am·min"},{"feet per hour":"zeptometers per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"zm/min, zeptometers per minute, zeptometer per minute, zmpm, zm·min"},{"feet per hour":"yoctometers per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"ym/min, yoctometers per minute, yoctometer per minute, ympm, ym·min"},{"feet per hour":"decameters per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"dam/min, decameters per minute, decameter per minute, dampm, dam·min"},{"feet per hour":"hectometers per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"hm/min, hectometers per minute, hectometer per minute, hmpm, hm·min"},{"feet per hour":"kilometers per minute","ft/h, feet per hour, foot per hour, fph, ft·h":"km/min, kilometers per minute, kilometer per minute, kmpm, km·min"},{"feet per hour":"meters per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"m/h, meters per hour, meter per hour, m·h"},{"feet per hour":"decimeters per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"dm/h, decimeters per hour, decimeter per hour, dmph, dm·h"},{"feet per hour":"centimeters per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"cm/h, centimeters per hour, centimeter per hour, cmph, cm·h"},{"feet per hour":"millimeters per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"mm/h, millimeters per hour, millimeter per hour, mmph, mm·h"},{"feet per hour":"microns per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"µm/h, microns per hour, micron per hour, µmph, µm·h"},{"feet per hour":"nanometers per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"nm/h, nanometers per hour, nanometer per hour, nmph, nm·h"},{"feet per hour":"picometers per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"pm/h, picometers per hour, picometer per hour, pmph, pm·h"},{"feet per hour":"femtometers per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"fm/h, femtometers per hour, femtometer per hour, fmph, fm·h"},{"feet per hour":"attometers per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"am/h, attometers per hour, attometer per hour, amph, am·h"},{"feet per hour":"zeptometers per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"zm/h, zeptometers per hour, zeptometer per hour, zmph, zm·h"},{"feet per hour":"yoctometers per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"ym/h, yoctometers per hour, yoctometer per hour, ymph, ym·h"},{"feet per hour":"decameters per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"dam/h, decameters per hour, decameter per hour, damph, dam·h"},{"feet per hour":"hectometers per hour","ft/h, feet per hour, foot per hour, fph, ft·h":"hm/h, hectometers per hour, hectometer per hour, hmph, hm·h 'metric per hour"}]}

Examples

select wct.CONVERTSPEED(3 * power(10, 8), 'm/s', 'mi/s');

Here is the result set.

{"columns":[{"field":"column 1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"186411.3576"}]}