SELECT CAST(AVG(DATEDIFF(DD,CreateOnTime,LastLoginErrorDateTime)*1.00) AS DECIMAL(8,2)) FROM T_AdminUsers
Sql数据精确度问题,保留指定的小数位------时间差
最新推荐文章于 2022-11-09 16:25:48 发布
SELECT CAST(AVG(DATEDIFF(DD,CreateOnTime,LastLoginErrorDateTime)*1.00) AS DECIMAL(8,2)) FROM T_AdminUsers