MINUTE()

All functions > DATE AND TIME > MINUTE()

Returns the minute component of a date or timestamp.

Signatures

Returns: The minute component

MINUTE(timestamp: T) → BIGINT
sql
ParameterTypeRequiredDescription
timestampTYesA DATE or TIMESTAMP value

With:

  • T : Custom types: DATE | TIMESTAMP

Notes

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

Examples

FeatureQL
RETURN
    -- Extract minute
    f1 := DATE_PART(FROM_ISO8601_TIMESTAMP('2024-03-15T10:30:45'), 'minute')
;
Result
f1 BIGINT
30