MS Access Minute() Function
THE WORLD'S LARGEST WEB DEVELOPER SITE
HTML CSS JAVASCRIPT SQL PHP BOOTSTRAP HOW TO JQUERY W3.CSS ANGULAR XML MORE FORUM EXAMPLES REFERENCES

MS Access Minute() Function

❮ MS Access Functions

Example

Return the minute of the hour for a specified time:

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

Definition and Usage

The Minute() function returns the minute of the hour (from 0 to 59) for a time value.

Syntax

Minute(time)

Parameter Values

Parameter Description
time Required. A valid time

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Return the minute of the hour for the current time:

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

Example

Return the minute of the hour for a specified date and time:

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

❮ MS Access Functions