FUNCTION fDMSbase

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

Input and output parameters

name type length inout pnum

@truncate int 4 input 2

@precision int 4 input 3

@deg float 8 input 1

varchar 32 input 0

name	type	length	inout	pnum
@truncate	int	4	input	2
@precision	int	4	input	3
@deg	float	8	input	1
	varchar	32	input	0