Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
TIMESTAMPADD
TIMESTAMPADD
The TIMESTAMPADD() function adds time value with a date or datetime value.
Syntax
TIMESTAMPADD(unit,interval,datetime_expr);
Example
SELECT TIMESTAMPADD(SQL_TSI_frac_second,4353,'1901-12-31 13:59:00' )