MySQL - MINUTE() function example

In this article, we would like to show you MINUTE() function example in MySQL.

Syntax:

SELECT MINUTE('YYYY-MM-DD hh:mm:ss');

Where:

• YYYY - four-digit year format, e.g. 2021,
• MM - month number (counted from 01 to 12),
• DD - day number (from 01 to 31 - depending on the month),
• hh - hour number (from 00 to 24),
• mm - minute number (from 00 to 59),
• ss - second number (from 00 to 59).

Practical example

In this example, we will use MINUTE() function to display only a minute from a DATETIME value.

Query:

SELECT MINUTE('2021-01-01 11:41:31');

Result:

Related posts

• MySQL - extract MINUTE from DATETIME / TIMESTAMP / TIME