FUNCTION
fDMS
Convert declination in degrees to +dd:mm:ss.ss notation.
SDSS SkyServer function, courtesy Johns Hopkins University.
Example usage:
SELECT dbo.fDMS(87.5)
=> +87:30:00.00
Name
Type
Length
inout
pnum
@deg
float
8
input
1
varchar
32
output
1