獲取美國日期的上週一到上週日數據
SELECT distinct billing_date
FROM dwd_two_week_data_type
WHERE billing_date >= date_add(next_day(date_format(from_utc_timestamp(to_utc_timestamp(current_timestamp(),'Asia/Shanghai'),'America/Los_Angeles'),'yyyy-MM-dd HH:mm:ss'), 'MO'), -14)
AND billing_date <= date_add(next_day(date_format(from_utc_timestamp(to_utc_timestamp(current_timestamp(),'Asia/Shanghai'),'America/Los_Angeles'),'yyyy-MM-dd HH:mm:ss'), 'MO'), -8);