_add_hours

Returns the time or datetime, depending on the format of "time_expression", that results from adding "integer_expression" hours to "time_expression".

Syntax

_add_hours ( time_expression, integer_expression )

Example 1

_add_hours ( 13:59:00 , 1 )

Result

14:59:00

Example 2

_add_hours ( 2002-04-30 12:10:10.000, 1 )

Result

2002-04-30 13:10:10.000,

Example 3

_add_hours ( 2002-04-30 00:00:00.000, 1/60 )
Note that the second 
argument is not a whole number. This is supported by some database 
technologies and increments the time portion.

Result

2002-04-30 00:01:00.000