实现方式:
cast函数 cast A as B
round(cast( A as B),2)
SELECT calculate_time,round(CAST("value" as numeric),2) as fcao from arithmetic.dws_tag_today where byt_name='hk_fcao'
and calculate_time > now() - interval '2 hour'
ORDER BY calculate_time desc limit 1