FUNCTION
fDMSbase
Base function to convert declination in degrees to +dd: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.fDMSbase(87.5,1,4)
select dbo.fDMSbase(87.5,default,default)
varchar
32
output
1