Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

MINUTE function (ODBC compatible)

Syntax

MINUTE ( time_expression )

Description

The scalar function MINUTE returns the minute value in the argument as a short integer in the range of 0 - 59.

Example

SELECT *

FROM arrivals

WHERE MINUTE (in_time) > 10 ;

Notes

  • 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.

TOCIndex