Create FUNCTION ConverData( @data float ) RETURNS varchar ( 20 ) AS BEGIN -- 度 declare @du float set @du = floor ( @data ) -- 分 declare @tfen float set @tfen = floor (( @data - floor ( @data )) * 60 ); -- 秒 declare @miao float set @miao = floor ((( @data - floor ( @data )) * 60 - floor ( @tfen )) * 60 ) return convert ( varchar ( 20 ), @du ) + ' ° ' + convert ( varchar ( 20 ), @tfen ) + ' ′ ' + convert ( varchar ( 20 ), @miao ) + ' ″ ' END