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:

Sisense supports the following date-part extractions:




:day_of_week (or :dow)


:day_of_year (or :doy)


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.