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

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:

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

• Time zone conversion
• Date part extraction
• Date aggregations
• Conversion to Dollars and Percents