ECharts sql语句

1.处理当天数据

SELECT  * FROM  table_name a WHERE
    a.trntime >=to_timestamp(to_char(now(),'YYYY-MM-dd'),'YYYY-MM-dd HH24:MI:SS')
AND 
    a.trntime <=to_timestamp(to_char(now(),'YYYY-MM-dd'),'YYYY-MM-dd HH24:MI:SS')+INTERVAL '1 day'+INTERVAL '-1 second'
-----------------------------------------------------------------------------------------------------
select to_timestamp(to_char(now(),'YYYY-MM-dd'),'YYYY-MM-dd HH24:MI:SS')    
-- 结果：2021-08-09 00:00:00+08    

select to_timestamp(to_char(now(),'YYYY-MM-dd'),'YYYY-MM-dd HH24:MI:SS')+INTERVAL '1 day'+INTERVAL '-1 second'  

结果：2021-08-09 23:59:59+08

----------------------------------------------------------------------------------------------------

最终

SELECT * FROM table_name a WHERE to_char(a.trntime,'YYYY-MM-dd') = to_char(now(),'YYYY-MM-dd')

这是结果 ：2021-08-06 00:00:00 ~ 2021-08-06 23:59:59

附加：

select sum(a.reportId) ,DATE_FORMAT(time,'%m')  FROM fc_his_report a WHERE DATE_FORMAT( t