Previous Topic: MIN Function--Determine the Lesser of Two Numbers

Next Topic: MOD Function--Return Division Remainder

MINUTE Function--Return the Minutes Component for a Date

The MINUTE function returns the number representing the minute component for a specified date_time expressed in seconds since January 1, 1970.

Syntax

The MINUTE function has the following format:

MINUTE(date_time)

Parameters

The MINUTE function accepts the following parameter:

date_time (number)

The date in the number of seconds.

Return Value

The MINUTE function returns a number between 0 and 59. If the date_time is invalid, MINUTE returns -1.

More information:

HOUR Function--Convert to Hour

HOUR24 Function--Convert to Hour

SECOND Function--Return the Number of Seconds in a Date


Copyright © 2010 CA. All rights reserved. Email CA about this topic