Date Parts

👤 This documentation is intended for SQL Users.

Use ":day_of_month", ":hour_of_day", etc. to convert dates and times to the appropriate date part. For example ":day_of_month" might return "22" and ":hour_of_day" might return "8".

Let's plot purchases by day of week:

Periscope supports the following date-part extractions:

:sec_of_min

:min_of_hour

:hour_of_day

:day_of_week (or :dow)

:day_of_month

:day_of_year (or :doy)

:month_of_year

Epoch Conversion

Use ":ts" to convert epoch or unix timestamps to a readable "YYYY-MM-DD HH:MI:SS" format. This can then be used with the above date part and date aggregation shortcuts.

[my_epoch_date:ts]

Our support team is ready to help