I'm working on a similar project (Access, Oracle, and Sybase, with SQL Server to come), and here's what we've found, as far as I know:<BR><BR>Mostly ANSI SQL will convert without changes.

-- Get the session time zone. -- Find the next week’s date from SYSDATE. -- SELECT SYSDATE+7 AS NEXTWEEK_DATE FROM DUAL -- Subtract 17 days from SYSDATE. -- SELECT SYSDATE-17 AS 17DAYSBACK FROM DUAL - ...

DATEDIFF is a common function in the SQL Server to find the number of days between two dates. Oracle offers its own solution, although does not have the DATEDIFF function. What's the function in ...

Hi Pavel, I have found an issue with the 'J' format of the oracle.to_date (text, text) function, it reports wrong results compared to Oracle. On Oracle: SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM ...