[IGNITE-3797] ODBC: Scalar functions: Support TIMESTAMPDIFF and TIMESTAMPADD functions.

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.7
• Component/s: platforms
• Labels: odbc
• Assignee: Unassigned
• Reporter: Igor Sapego
• Created: 29/Aug/16 14:50
• Updated: 22/Aug/17 07:32

Description

Currently we do not support TIMESTAMPDIFF, TIMESTAMPADD functions due to non-supported conversation from ODBC-specific interval types to interval types used by h2. LIst of ODBC interval types:
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

Issue Links

• relates to: IGNITE-3750 ODBC: Scalar functions: Support time/date functions.