mysql计算某列数据的除数并保留两位小数
SELECT
date( a.create_time ) AS createTime,
SUM( a.day_energy )/ 1000 AS dayEnergy,
CONVERT (SUM( a.day_energy )/ 1000,DECIMAL ( 15, 3 )) AS dayEnergy,
TRUNCATE ( SUM( a.day_energy )/ 1000, 3) AS dayEnergy,
SUM( a.profit ) AS profit
FROM
ems_photovoltaic_day_gen_record a
结果:
2024-06-28 84.50390000 84.504 84.503 7175.31
参考: