SQL Language (MOSC)

MOSC Banner

ODBC compliant function in Oracle for TIMESTAMPADD.

edited Nov 12, 2019 4:04AM in SQL Language (MOSC) 2 commentsAnswered

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())}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center