FUNCTION
fHMSbase
Base function to convert right ascension in degrees to +hh:mm:ss.ss notation.
Name
Type
Length
inout
pnum
@deg
float
8
input
1
@truncate
int
4
input
2
@precision
int
4
input
3
SDSS SkyServer function, courtesy Johns Hopkins University.
@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.fHMS(187.5,1,3)
select dbo.fHMS(187.5,default,default)
varchar
32
output
1