| 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