Sql数据精确度问题,保留指定的小数位------时间差

技术2022-07-13 86

SELECT CAST(AVG(DATEDIFF(DD,CreateOnTime,LastLoginErrorDateTime)*1.00) AS DECIMAL(8,2)) FROM T_AdminUsers

Processed: 0.018, SQL: 9