select max(concat(to_char(scada_time + '8 hour','YYYY-MM-DD HH24:MI'),'-',fields_value)) as max_fields_value ,to_char(scada_time + '8 hour','YYYY-MM-DD') as day_time1 ,tab_name from dw.tbl_dw_smom_scada_data where tab_name = '电1040582'${if(adat !=to_char(CURRENT_DATE ,'YYYY-MM'),'to_char(scada_time + '8 hour','YYYY-MM-DD') = DATE_TRUNC('month', adat) + INTERVAL '1 month - 1 day'','to_char(scada_time + '8 hour','YYYY-MM-DD') = to_char(CURRENT_DATE- INTERVAL '1 day' ,'YYYY-MM-DD')')} group by to_char(scada_time + '8 hour','YYYY-MM-DD'),tab_name这边参数不会写报错:${if(adat !="to_char(CURRENT_DATE ,'YYYY-MM')"," and to_char(scada_time + '8 hour','YYYY-MM-DD') = DATE_TRUNC('month', TO_DATE(adat,'YYYY-MM')) + INTERVAL '1 month - 1 day'"," and to_char( scada_time + '8 hour','YYYY-MM-DD') = to_char(CURRENT_DATE- INTERVAL '1 day' ,'YYYY-MM-DD')")} group by to_char(scada_time + '8 hour','YYYY-MM-DD'),tab_name