helpful-carpenter-320802/24/2023, 7:48 PM
to filter the timestamp. And we use the UTC time in the experiment settings. but by default Clickhouse is using the server timezone which is not UTC. so the fix should be add UTC in the toDateTime function like this
Can anyone help on this?
toDateTime('2023-02-24 17:00:00', 'UTC')
__experiment as (-- Viewed Experiment SELECT e.user_id as user_id, toString(e.variation_id) as variation, e.timestamp as timestamp, e.timestamp as conversion_start, dateAdd(hour, 720, e.timestamp) as conversion_end FROM __rawExperiment e WHERE e.experiment_id = 'SOME_EXP_ID' AND e.timestamp >= toDateTime('2023-02-24 17:00:00') )