IBM PureData System for Analytics, Version 7.1

The hours_between() function

The hours_between() function determines the truncated number of full hours between two timestamps.

Description

The hours_between() function has the following syntax:
int = hours_between(timestamp t1, timestamp t2);

The t1 value specifies the beginning timestamp.

The t2 value specifies the ending timestamp.

Returns

Returns the truncated number of full hours between t1 and t2. For example:
select hours_between('1996-02-27 06:12:33' , '1996-03-01 07:12:33');
 HOURS_BETWEEN
---------------
            73
(1 row)


Feedback | Copyright IBM Corporation 2014 | Last updated: 2014-02-28