helpful-carpenter-3208
02/24/2023, 7:48 PMtoDateTime
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 toDateTime('2023-02-24 17:00:00', 'UTC')
Can anyone help on this?
__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')
)
fresh-football-47124