MINUTES function [Date and time]

Function

Returns the number of minutes since an arbitrary date and time, the number of whole minutes between two specified times, or adds the specified integer-expression number of minutes to a time.

Syntax

MINUTESdatetime-expression
| datetime-expression, datetime-expression
| datetime-expression, integer-expression )

Parameters

datetime-expression A date and time.

integer-expression The number of minutes to be added to the datetime-expression. If integer-expression is negative, the appropriate number of minutes are subtracted from the date/time. If you supply an integer expression, the datetime-expression must be explicitly cast as a datetime data type.

For information on casting data types, see “CAST function [Data type conversion]”.

Examples

The following statement returns the value 1051125487:

SELECT MINUTES( '1998-07-13 06:07:12' ) FROM iq_dummy

The following statement returns the value 240, to signify the difference between the two times:

SELECT MINUTES( '1999-07-13 06:07:12',
	'1999-07-13 10:07:12' ) FROM iq_dummy

The following statement returns the datetime value 1999-05-12 21:10:07.000:

SELECT MINUTES( CAST( '1999-05-12 21:05:07'
AS DATETIME ), 5) FROM iq_dummy

Usage

The second syntax returns the number of whole minutes from the first date/time to the second date/time. The number might be negative.

Standards and compatibility