This function is used to calculate the actual unit of conversion for angle.
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 angle.
This is a most advanced generic function , which suppose to return values for 6 combinations.
Regards,
Vignesh Arulmani
create function fn_calc_uoc_angle(@FromConversionUnit varchar(64),@ToConversionUnit varchar(64),@UnitValue float)
returns float
as
begin
--ANGLE
declare @returnvalue float
select @returnvalue =
case
when @FromConversionUnit = 'degree' and @ToConversionUnit = 'gradian' then @UnitValue * 1.111111111111111
when @FromConversionUnit = 'degree' and @ToConversionUnit = 'radian' then @UnitValue * 0.0174532925199433
when @FromConversionUnit = 'gradian' and @ToConversionUnit = 'degree' then @UnitValue * 0.9
when @FromConversionUnit = 'gradian' and @ToConversionUnit = 'radian' then @UnitValue * 0.015707963267949
when @FromConversionUnit = 'radian' and @ToConversionUnit = 'degree' then @UnitValue * 57.29577951308233
when @FromConversionUnit = 'radian' and @ToConversionUnit = 'gradian' then @UnitValue * 63.66197723675814
when @FromConversionUnit = @ToConversionUnit then @UnitValue * 1.0
end
return(@returnvalue)
end
go
--examples
select dbo.fn_calc_uoc_angle('degree','gradian',10)
select dbo.fn_calc_uoc_angle('degree','radian',10)
select dbo.fn_calc_uoc_angle('gradian','degree',10)
select dbo.fn_calc_uoc_angle('gradian','radian',10)
select dbo.fn_calc_uoc_angle('radian','degree',10)
select dbo.fn_calc_uoc_angle('radian','gradian',10)