SET @FULLHOUR='CAST(FLOOR(CAST('+ 'RepTime' +' AS FLOAT)*24)/24+1e-8 AS DATETIME)'
SET @FULLDAY='CAST(FLOOR(CAST('+ 'RepTime' +' AS FLOAT))+1e-8 AS DATETIME)'
时间转换成小时,天
最新推荐文章于 2021-02-11 22:56:17 发布
SET @FULLHOUR='CAST(FLOOR(CAST('+ 'RepTime' +' AS FLOAT)*24)/24+1e-8 AS DATETIME)'
SET @FULLDAY='CAST(FLOOR(CAST('+ 'RepTime' +' AS FLOAT))+1e-8 AS DATETIME)'