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
(
@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