KELVIN

Updated 2023-11-09 15:09:28.947000

Syntax

SELECT [westclintech].[wct].[KELVIN] (
  <@Temperature, float,>
 ,<@From_scale, nvarchar(4000),>)

Description

Use the scalar function KELVIN to convert from Celsius, Fahrenheit or Rankine to Kelvin.

Arguments

@Temperature

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

@From_scale

is the description of the units for @Temperature. @From_scale must be a valid value as specified in temperature unit representations. @From_scale must be of a data type that is implicitly convertible to varchar.

Return Type

float

Remarks

KELVIN is calculated according the following formula:K° = C° + 237.15K° = (F° + 459.67) * 5 / 9K° = R° * 5 / 9

Examples

select wct.KELVIN(100, 'C');

Here is the result set.

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