Time Intelligence Functions
Legacy Feature
Starting from April 19, 2024, Business Calculation and Holistics Expression are no longer supported for new user signups, and are only be available for legacy use cases.
Holistics Expression is now replaced by AQL Expression with enhanced functionality.
epoch()
epoch(date)
epoch(datetime)
Description
epoch returns a Unix timestamp which is the number of seconds that have elapsed since ‘1970-01-01 00:00:00’ UTC.
You can use this function to return a Unix timestamp based on the current date/time or another specified date/time.
Return type
Vary
Example
Given a Holistics expression as below:
epoch(created_at)
The result would be:
| created_at | epoch(created_at) |
|---|---|
| 2018-06-12 09:26:49 | 1528795609 |
| 2018-06-12 | 1528761600 |