{DATEADD| TIMESTAMPADD} (unitString, addIntLong, timestamp)

Description

Adds units to a timestamp. The string indicates the unit. Use negative values to subtract units. addIntLong may be a long value when manipulating milliseconds, otherwise it's range is restricted to int. The same units as in the EXTRACT function are supported. DATEADD method returns a timestamp. TIMESTAMPADD method returns a long.

Examples

DATEADD('MONTH', 1, DATE '2001-01-31')