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:
![](https://cdn.prod.website-files.com/58fe8f93dc9e750ca84ebb16/5e0ea206f72affce0a46c0a9_Using%20SQL%20Formatters.png)
select [my_timestamp_column:pst] from my_table
select [my_timestamp_column:date] from my_table
Sisense for Cloud Data Teams 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:
![](https://cdn.prod.website-files.com/58fe8f93dc9e750ca84ebb16/5c0078fd73c94683e93ce297_SQL%20Format%20pst%20query.png)
Sisense supports many different kinds of formatters, including the following:
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form