Minute

Return the minute of the hour (a number from 0 to 59) given a time value.

Syntax
      Minute(time_value)

Key
   time_value  A valid time.

The minute() function may be used in VBA or in an SQL query.

Examples

Dim intDemo as integer
intDemo = minute(dtmShiftEnd)
intDemo = minute(#08:55:30 AM#)

Select * from orders where minute(Order_date) = 30;

“For a moment, nothing happened. Then, after a second or so, nothing continued to happen” ~ Douglas Adams

Related:

Day - Return the day of the month.
DatePart - Return part of a given date.
Second - Return the seconds of the minute


© Copyright SS64.com 1999-2014
Some rights reserved