Base function to convert declination in degrees to +dd:mm:ss.ss notation. |
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. Example usages: SELECT dbo.fDMSbase(87.56789,1,4) => +87:34:04.4040 SELECT dbo.fDMSbase(87.56789,default,default) => +87:34:04.40 |
Name | Type | Length | inout | pnum |
@deg | float | 8 | input | 1 |
@truncate | int | 4 | input | 2 |
@precision | int | 4 | input | 3 | varchar | 32 | output | 1 |