I'm looking as trying to use the same queries for an application to run on both Oracle 9 (which has fair ANSI compatibility) and MySQL 4.1.x. Most areas have been addressed, but the dates are where I'm having issues. SYSDATE and NOW() don't appear to be equal as well as doing date math. SYSDATE - 1 on Oracle is yesterday, NOW() - 1 is not. Anyone developed applications that work on both systems without separate queries for date functionality?

Thanks,
Steve

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to