在SQL Server 2005中将浮点8.07转换为字符串08:07

这个怎么样:

DECLARE @value DECIMAL(9,2) = 8.07

SELECT REPLACE(RIGHT(@value  + 1000000, 5), '.', ':');

当然,你可以改变你给一些小东西增加的价值。

DECLARE @t FLOAT = 8.073

SELECT @t AS t,
       ROUND(@t, 2) AS trunc_t, 
       REPLACE(RIGHT('00' + CAST(ROUND(@t, 2) AS VARCHAR(5)), 5), '.', ':') AS time_t

得到:

t      trunc_t  time_t
---------------------
8.073  8.07     08:07