ODBC compliant function in Oracle for TIMESTAMPADD.
Does anyone know if Oracle uses any of these ODBC compliant functions like TIMESTAMPADD and if so, give an example?
I saw many under mySQL but not Oracle, as Oracle looks like it only uses it's own date/time functions.
To give some context, we have this ODBC compliant Select in SQL Server and want an equivalent in Oracle that uses the same ODBC functionality.
SELECT {fn TIMESTAMPADD(SQL_TSI_YEAR, 1, GETDATE())}