You can use several ODBC functions in your expressions.
Format
expr-primary-odbc-timestampadd |
expr-primary-odbc-timestampdiff
Remarks
An ODBC function can be either of the following:
- A TIMESTAMPADD function. Refer to expr-primary-odbc-timestampadd for more details.
- A TIMESTAMPDIFF function. Refer to expr-primary-odbc-timestampdiff for more details.
Example:
{ FN TIMESTAMPADD( SQL_TSI_SECOND, 15, TIMESTAMP '2025-08-02 00:00:00' ) }
{ FN TIMESTAMPDIFF( SQL_TSI_MINUTE, TIMESTAMP '2025-08-02 00:00:00', TIMESTAMP '2025-08-02 00:15:00' ) }