EXTRACTEPOCH

This function returns the total number of seconds in the interval of the input timestamp value. Also see EXTRACT.

Syntax

SELECT EXTRACT(EPOCH FROM TIMESTAMP timestamp_expr);