MS Access Minute() Function

The Minute() function in MS Access extracts the minute component from a time or datetime value. It's useful for working with time data and performing time-based analysis or filtering.

Minute(): Definition and Usage

Minute() is particularly helpful when you need to focus on the minute portion of a time. You might use it to analyze events based on their minute, create detailed time logs, or filter data based on specific minute intervals. The function always returns an integer between 0 and 59.

Syntax


Minute(time)

Parameter Values

Parameter	Description
`time`	A time or datetime value (can be a literal like `#14:48:23#`, a field name, or an expression that evaluates to a time/datetime). This is required.

Examples

Extracting Minutes from a Time

This example extracts the minute part (48) from the time 2:48:23 PM.

Syntax


SELECT Minute(#14:48:23#);

Output

Extracting Minutes from the Current Time

This gets the current minute from the system clock.

Syntax


SELECT Minute(Now());

Output


(The current minute, a number between 0 and 59)

Extracting Minutes from a Datetime

This shows extracting the minute from a specific datetime value.

Syntax


SELECT Minute(#24/10/2016 11:18:34 PM#);