minute

Return the minute

Syntax

minute(dt_expr)

Arguments

dt_expr

A time expression.

Description

This function returns the minute component in the specified time expression as a number between 0 and 59.

Example

select minute(curtime()) as "Current Minute";

Current Minute
            22