ADD_HOURS

Purpose

This function adds a specified number of hours to a timestamp.

Syntax

add_hour::=

Add Hour

Usage Notes

  • Decimals are rounded before adding the number.
  • For data type TIMESTAMP WITH LOCAL TIME ZONE this function is calculated internally within UTC before the result is transformed to the session time zone.

Example

SELECT ADD_HOURS(TIMESTAMP '2000-01-01 00:00:00', 1) AH1,
       ADD_HOURS(TIMESTAMP '2000-01-01 12:23:45', -1) AH2;
Result
AH1 AH2
2000-01-01 01:00:00.000000 2000-01-01 11:23:45.000000