SECOND
Returns the seconds portion of the specified date as an integer.
Syntax
SECOND ( date )
Behavior Type
Immutable, except for TIMESTAMPTZ arguments where it is stable.
Parameters
date |
The date to process, one of the following data types: |
Examples
=> SELECT SECOND ('23:34:03.456789'); SECOND -------- 3 (1 row) => SELECT SECOND (TIMESTAMP 'sep 22, 2011 12:34'); SECOND -------- 0 (1 row) => SELECT SECOND (INTERVAL '35 12:34:03.456789'); SECOND -------- 3 (1 row)