HOUR()

All functions > DATE AND TIME > HOUR()

Returns the hour component of a date or timestamp.

Signatures

Returns: The hour component

HOUR(timestamp: T) → BIGINT

With:

• T : Custom types: DATE | TIMESTAMP

Notes

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

Examples

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