代元培

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.