unixepoch

Applies unixepoch modifier to a date/time value.

This function applies the 'unixepoch' modifier in SQLite, which transforms the date/time value into the number of seconds that have elapsed since 1970-01-01 00:00:00 UTC. The result is typically a large integer.

Note that if this modifier is used on a date/time string that is not in UTC, the utc modifier should be applied first to ensure the conversion is correct.

Example

// Get the current time as a Unix timestamp
select(DATETIME().now().unixepoch()).execute()

See also