Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

MINUTE

Example

Retrieve the minute component from a datetime value.

SELECT MINUTE(“2017-06-20 09:34:00”);

Definition and Usage

The MINUTE() function retrieves the minute part of a time or datetime value, ranging from 0 to 59.

Syntax

MINUTE(datetime)

Parameter Values

Parameter

Description

datetime

Mandatory: The time or datetime from which to extract the minute.

Technical Details

Works in:

 From MySQL version 4.0

More Examples

Example

Retrieve the minute component from a given time value.

SELECT MINUTE(“23:59:59”);