1. Home
  2. Other Releases
  3. On-premises 5.1
  4. Guides
  5. Tours
  6. Concepts
  7. Tools
  8. References
  9. Integrations
  10. Data applications
  11. Releases

Built-in Functions → epoch

epoch() is a conversion function that returns the number of seconds since the epoch given a timestamp value.

Note

The epoch or "Unix Time" is the time elapsed since January 1, 1970.

Signature

epoch(date_timestamp exp)
  • date_timestamp exp : The date or timestamp value

Returns

long

Example

Return the number of seconds since the epoch for Sales_Date.

epoch(SALES.Sales_Date_dim.Sales_Date)