SECOND()

All functions > DATE AND TIME > SECOND()

Returns the second component of a date or timestamp.

Signatures

Returns: The second component

SECOND(timestamp: T) → BIGINT

With:

• T : Custom types: DATE | TIMESTAMP

Notes

• Permissive spelling of DATE_PART(timestamp, 'second')
• Also accepts TIMESTAMP

Examples

RETURN
    -- Extract second
    f1 := DATE_PART(FROM_ISO8601_TIMESTAMP('2024-03-15T10:30:45'), 'second')
;