MINUTE

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
  X   X

This function is used to extract the minute part of a time or timestamp. The result is an integer between 0 and 59 (or null if time-expr evaluates to a null value).

The format appears below:

MINUTE(time-expr)

For example:

SELECT MINUTE(endtime)
FROM tasks