Convert a datetime to to a given timezone by putting the time zone name in brackets, e.g.
select [created_at:pst] from users -- Convert created_at to Pacific Time select [created_at:est] from users -- Convert created_at to Eastern Time
To verify Periscope's timezone math, click on the "Query" tab to display the expanded SQL.
The following timezones are currently supported:
:est :cst :mst :pst :hawaii
:pet :brt :cot
:gmt :wet :cet :eet
:awst :acst :acdr :aest :aedt
:wib :myt :sgt
American time zones use the current UTC offset to convert all dates. They will be off by one hour for historical time ranges with alternating daylight savings time offsets.
To perform the (more expensive) historically accurate conversion, prepend an "h" for "historical", e.g.:
select [created_at:hpst] from users select [created_at:hmst] from users select [created_at:hcst] from users select [created_at:hest] from users