IBM PureData System for Analytics, Version 7.1

The minutes_between() function

The minutes_between() function determines the truncated number of full minutes between two timestamps.

Description

The minutes_between() function has the following syntax:

bigint = minutes_between(timestamp t1, timestamp t2);

The t1 value specifies the beginning timestamp.

The t2 value specifies the ending timestamp.

Returns the truncated number of full minutes between t1 and t2. For example:

select minutes_between('1996-02-27 06:12:33' , '1996-02-27 07:12:00');
 MINUTES_BETWEEN
-----------------
              59
(1 row)