posthog icon indicating copy to clipboard operation
posthog copied to clipboard

fix(data-warehouse): Fixed reading unix timestamps in a TZ-aware way

Open Gilbert09 opened this issue 9 months ago • 0 comments

Problem

  • We had duplicate days when plotting Stripe data in product analytics due to the way we were parsing unix timestamps from data warehouse
image

Changes

  • Use the timezone-aware function of toDateTime when reading unix timestamps for Stripe and other integration data

Does this work well for both Cloud and self-hosted?

  • Yes

How did you test this code?

  • Via browser clicky clicks

Gilbert09 avatar May 01 '24 14:05 Gilbert09