FUNCTION  fHMSbase

Base function to convert right ascension in degrees to +hh:mm:ss.ss notation.

@truncate is 0 (default) if decimal digits to be rounded, 1 to be truncated.
@precision is the number of decimal digits, default 2.

select dbo.fHMSBase(187.5,1,3)
select dbo.fHMSBase(187.5,default,default)

Input and output parameters

nametypelengthinoutpnum
@truncateint4input2
@precisionint4input3
@degfloat8input1
 varchar32input0