THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Minute() Function

❮ MS Access Functions

Example

Return the minute part of a specified time:

SELECT Minute(#14:48:23#);
Try it Yourself »

Definition and Usage

The Minute() function returns the minute part of a time/datetime.

This function returns an integer between 0 and 59.

Syntax

Minute(time)

Parameter Values

Parameter Description
time Required. A numeric or string expression that can represent a valid time/datetime

Technical Details

Works in: From Access 2000

More Examples

Example

Return the minute part of the current time:

SELECT Minute(Now());
Try it Yourself »

Example

Return the minute part of a specified datetime:

SELECT Minute(#24/10/2016 11:18:34 PM#);
Try it Yourself »

❮ MS Access Functions