代元培

SUM( IF [f_business_time] >= DATETRUNC('day', DATEADD('day', -1, NOW())) AND [f_business_time] < DATETRUNC('day', NOW()) AND ((10000000 <= [f_trans_buyer_user_id] AND [f_trans_buyer_user_id] <= 999999999999999) OR.

# 今天 DATETRUNC('day', NOW()) # 昨天 DATETRUNC('day', DATEADD('day', -1, NOW())) # 明天 DATETRUNC('day', DATEADD('day', 1, NOW())) # 本月第一天 DATETRUNC('month', NOW()) # 上月第一天 DATETRUNC('month', DATEADD('month', -1, NOW())) # 上个月的今天 DATETRUNC('day', DATEADD('mont.