[SQL]YYYYMMDD·Á¼°¤Î¿ôÃͤòÆüÉÕ·¿¤ËÊÑ´¹¤¹¤ëÊýË¡

DECLARE @fDate float
SET @fDate = 20041001
SELECT CONVERT(datetime,CAST(CONVERT(int, @fDate) AS char(8)));