SQL · Date and time functions

unixepoch()

Seconds since the Unix epoch.

sqlRunnable example sql course

Syntax

unixepoch(timestring)

Example

Open in the lab

SELECT unixepoch('2026-11-01T00:00:00Z') AS seconds;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.