Beginner

275. MINUTE Function

Learn how to extract the minute component from a time value.

📘 Lesson 275 of 728 ⏱ 8 min 🎯 Intermediate

The MINUTE function extracts the minute component from a time or timestamp value.

Minute-level information can help analyze transaction timing, system events, and operational activity.

Extract the minute from a transaction timestamp.

SQL 
SELECT
    TransactionID,
    MINUTE(TransactionTime) AS TransactionMinute
FROM Transactions;

MINUTE can be useful in real-time monitoring, transaction analysis, system logs, and operational reporting.

  • MINUTE extracts the minute component.
  • The result is normally between 0 and 59.
  • It can support detailed time analysis.
  • It is useful with timestamps.
  • Database syntax can vary.
What does MINUTE do?

MINUTE extracts the minute component from a time or timestamp value.

What range can the minute component have?

The minute component normally ranges from 0 through 59.

Have you finished this lesson?

Introduction to SQL – All Lessons