Figure 2


Keywords to express valid TIMESTAMPADD interval or TIMESTAMPDIFF interval values; fractional seconds are expressed in billionths of a second.

SQL_TSI_FRAC_SECOND
SQL_TSI_SECOND
SQL_TSI_MINUTE
SQL_TSI_HOUR
SQL_TSI_DAY
SQL_TSI_WEEK
SQL_TSI_MONTH
SQL_TSI_QUARTER
SQL_TSI_YEAR