pgsql CURRENT_DATE 当前日期 加减日期 混合case when sum()
写法如下:
SUM ( CASE WHEN ai.date_due <= CURRENT_DATE - INTERVAL '90 day' AND
ai.date_due > CURRENT_DATE - INTERVAL '120 day' THEN amount_total END )
AS date120
mysql
from_unixtime 加减小时
from_unixtime( ho.pay_time, '%Y-%m-%d %k:%i:%s' )+ INTERVAL 8 HOUR AS pay_time,
+ INTERVAL 8 HOUR