MINUTE Function [Date and Time]

Returns a number from 0 to 59 corresponding to the minute component of the specified date/time value.

Syntax

MINUTEdatetime-expression )

Parameters

Parameter

Description

datetime-expression

The date/time value.

Returns

SMALLINT

Example

The following statement returns the value 22:

SELECT MINUTE( '1998-07-13 12:22:34' ) FROM iq_dummy

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Compatible with Adaptive Server Enterprise.