Finance says total card spend for March is 10 million dollars, but when you sum the warehouse by transaction date you get 10.12 million. The warehouse stores timestamps in UTC, while finance uses Eastern Time. How would you track down the gap, and roughly which time windows are causing it?

财务说3月信用卡消费总额是1000万，你从数仓按交易日期汇总出来却是1012万。数仓时间存的是UTC，财务按美东时间算。你会怎么定位差异？大概差在哪几个时间段？