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]