MINUTE

Returns the minute value in the argument as a short integer in the range of 0-59.

Syntax

MINUTE ( time_expression )

The argument to the function must be of type TIME.

The argument must be specified in the format HH:MI:SS.

The result is of type SHORT.

If the argument expression evaluates to NULL, the result is NULL.

This example illustrates the MINUTE function:

SELECT *
FROM arrivals
WHERE MINUTE (in_time) > 10 ;

ODBC compatible