This function is used to calculate the actual unit of conversion for temperature.
This is a most advanced generic function , which suppose to return values for 6 combinations.
Regards,
Vignesh Arulmani
This function is used to calculate the actual unit of conversion for temperature.
This is a most advanced generic function , which suppose to return values for 6 combinations.
Regards,
Vignesh Arulmani
create function fn_calc_uoc_temperature(@FromConversionUnit varchar(64),@ToConversionUnit varchar(64),@UnitValue float)
returns float
as
begin
--TEMPERATURE
/*============ACRONYM=========
DC - Degrees Celcius
DF - Degrees Fahrenheit
K - Kelvin
*/
declare @returnvalue float
select @returnvalue =
case
when @FromConversionUnit = 'DC' and @ToConversionUnit = 'DF' then @UnitValue * 33.8
when @FromConversionUnit = 'DC' and @ToConversionUnit = 'K' then @UnitValue * 274.15
when @FromConversionUnit = 'DF' and @ToConversionUnit = 'DC' then @UnitValue * -17.22222222222222
when @FromConversionUnit = 'DF' and @ToConversionUnit = 'K' then @UnitValue * 255.9277777777778
when @FromConversionUnit = 'K' and @ToConversionUnit = 'DC' then @UnitValue * -272.15
when @FromConversionUnit = 'K' and @ToConversionUnit = 'DF' then @UnitValue * -457.87
when @FromConversionUnit = @ToConversionUnit then @UnitValue * 1.0
end
return(@returnvalue)
end
go
--examples
select dbo.fn_calc_uoc_temperature('DC','DF',10)
select dbo.fn_calc_uoc_temperature('DC','K',10)
select dbo.fn_calc_uoc_temperature('DF','DC',10)
select dbo.fn_calc_uoc_temperature('DF','K',10)
select dbo.fn_calc_uoc_temperature('K','DC',10)
select dbo.fn_calc_uoc_temperature('K','DF',10)