Using SQL Formatters

👤 This section is intended for SQL Users.

Ensure the date and time columns are in the right time zone using simple formatters:

select [my_timestamp_column:pst] from my_table 
select [my_timestamp_column:date] from my_table

Periscope can compose multiple formatters at once, e.g.:

select [my_timestamp_column:pst:date] from my_table

This query will select gameplays by PST date over time:

The "Query" button above the chart will display the expanded SQL Periscope generated:

Periscope supports many different kinds of formatters, including the following:

Our support team is ready to help