SELECT CAST(AVG(DATEDIFF(DD,CreateOnTime,LastLoginErrorDateTime)*1.00) AS DECIMAL(8,2)) FROM T_AdminUsers
Sql数据精确度问题,保留指定的小数位------时间差
最新推荐文章于 2024-04-26 13:21:41 发布
SELECT CAST(AVG(DATEDIFF(DD,CreateOnTime,LastLoginErrorDateTime)*1.00) AS DECIMAL(8,2)) FROM T_AdminUsers