MHR

Updated 2023-11-09 14:46:19.907000

Syntax

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

Description

Use the scalar function MHR to convert 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 to meters per hour.

Arguments

@From_scale

is the description of the units for @Speed. @From_scale must be a valid value as specified in speed 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.

is the description of the metric units that @Speed is to be converted into. @To_scale must be a valid value as specified in speed unit representations. In addition to meters per hour, @To_scale  can be decimeters per hour, centimeters per hour, millimeters per hour, micrometers per hour, nanometers per hour, picometers per hour, femtometers per hour, attometers per hour, zeptometers per hour, yoctometers per hour, decameters per hour, hectometers per hour or kilometers per hour. @To_scale must be of a data type that is implicitly convertible to varchar.

Return Type

float

Remarks

The following table is a representation of the conversion of one of the speed units of measure into meters per hour:

{"columns":[{"field":"column 1"},{"field":"column 2","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"feet per hour","column 2":"0.3048"},{"column 1":"feet per minute","column 2":"18.288"},{"column 1":"feet per second","column 2":"1097.28"},{"column 1":"inches per second","column 2":"91.44"},{"column 1":"kilometers per hour","column 2":"1000"},{"column 1":"knots","column 2":"1852"},{"column 1":"miles per hour","column 2":"1609.344"},{"column 1":"miles per minute","column 2":"96560.64"},{"column 1":"miles per second","column 2":"5793638"},{"column 1":"meters per second","column 2":"3600"},{"column 1":"meters per minute","column 2":"60"},{"column 1":"meters per hour","column 2":"1"}]}

Conversion of meters includes all the standard prefixes with kilo representing 1,000 and yocto representing 10E-24.

Examples

select wct.MHR(10, 'm/s', 'km/h');

Here is the result set.

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