shy-river-3564711/15/2023, 5:43 PM
. So when we try to run the growthbook queries in presto, the
part of the query executes the following part which readjusts the timestamp.
The original timestamp ‘2023-07-22T070000.000Z’ is in Coordinated Universal Time (UTC), but the output indicates a time of midnight (000000) with a time zone offset of -0700. this actually creates a gap of 14h which is not expected. Is it possible to customize options here to stick to Pacific timezone all throughout growthbook ?
AND e.timestamp >= from_iso8601_timestamp('2023-07-22T07:00:00.000Z')
rhythmic-agent-3420811/16/2023, 6:39 PM