HOURS_BETWEEN

Purpose

This function returns the number of hours between timestamp timestamp1 and timestamp timestamp2.

Syntax

hours_between::=

Hours Between

Usage Notes

  • If timestamp timestamp1 is earlier than timestamp timestamp2, then the result is negative.
  • For data type TIMESTAMP WITH LOCAL TIME ZONE this function is calculated internally within UTC.

Example

Copy 
SELECT HOURS_BETWEEN(TIMESTAMP '2000-01-01 12:00:00',
                     TIMESTAMP '2000-01-01 11:01:05.1') HB;