bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access Minute() Function

Concept visual

MS Access Minute() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Return the minute part of a specified time:

Select

Minute(#14:48:23#);

Definition and Usage

Formula

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

Formula

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());

Example

Return the minute part of a specified datetime:

Select

Formula

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

Previous

❮ MS Access Functions

Next

Previous

MS Access Hour() Function

Next

MS Access Month() Function