This topic describes how to use the date function MINUTE in Realtime Compute.

Syntax

BIGINT MINUTE(TIME time) 
BIGINT MINUTE(TIMESTAMP timestamp)

Input parameters

Parameter Data type
time TIME
timestamp TIMESTAMP

Description

Returns the minute component of the specified time or timestamp value. The return value ranges from 0 to 59.

Example

  • Test data
    datetime1 (VARCHAR) time1 (VARCHAR) time2 (TIME) timestamp1 (TIMESTAMP)
    2017-10-15 11:12:13 22:23:24 22:23:24 2017-10-15 11:12:13
  • Test statements
    SELECT MINUTE(TIMESTAMP '2016-09-20 23:33:33') as int1,
     MINUTE(TIME '23:30:33') as int2,
     MINUTE(time2) as int3,
     MINUTE(timestamp1) as int4,
     MINUTE(CAST(time1 AS TIME)) as int5,
     MINUTE(CAST(datetime1 AS TIMESTAMP)) as int6
    FROM T1;
  • Test results
    int1 (BIGINT) int2 (BIGINT) int3 (BIGINT) int4 (BIGINT) int5 (BIGINT) int6 (BIGINT)
    33 30 23 12 23 12