MINUTE Function

Description

The MINUTE function returns the minutes in the range of 0 to 59 from specified argument. You can specify the TIME, TIMESTAMP, or DATETIME type; the value is returned in INTEGER type.

Syntax

MINUTE(time)

Example

SELECT MINUTE('12:34:56');

   minute('12:34:56')

=====================

                   34

 

SELECT MINUTE('2010-01-01 12:34:56');

   minute('2010-01-01 12:34:56')

================================

                              34

 

SELECT MINUTE('2010-01-01 12:34:56.7890');

   minute('2010-01-01 12:34:56.7890')

=====================================

                                   34

 

SELECT MINUTE('2010-01-01');

 

  In the command from line 1,

  ERROR: Conversion error in time format.