Hi,
I am facing a problem. Suppose while tracking an event the device time is in different zone, collector is in different zone and my server is in different time zone.
e.g :
If device is in IST and collector is in UTC and my server is in CDT. Now I am tracking events in some separate table as well where I am storing server time stamp which is in CDT. Now I want to join my event table with that other table using collector time stamp but i can not because both time stamps are different.
I am thinking to send server time as a separate parameter (say ttm) so that i can join my other event table with snowplow events table using ttm instead of collector time stamp. But I am not able to send ttm as parameter? Is there any way I can achieve this?
Thanks