These functions return a time by adding a specified number of time units to a time.
addseconds(time_value, time_units)
addminutes(time_value, time_units)
addhours(time_value, time_units)
adddays(time_value, time_units)
addmonths(time_value, time_units)
addyears(time_value, time_units)
The number of time units that represent the amount of time to be added to time_value. For example, for the addseconds function, this parameter is the number of seconds to be added. To compute a past time relative to time_value, pass a negative number for this parameter.
If you enter a float value for this parameter, such as 5.4 or 27.9, only the integer part of the number is used. For example, 5.4 becomes 5.
addhours(Entry_time, num_hours)
The algorithm for the addmonths and addyears functions might differ from the way that comparable calculations are made in various development environments.
addmonths(convert("01/31/1997 12:00:00", time), 1)
addyears(convert("02/29/2000 12:00:00", time), 1)