Re: Oracle 9 / MySQL date compatibility

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 28 Oct 2004 01:08:27 GMT
Message-ID: <eEXfd.537021$8_6.164712@attbi_s04>

"Steve W" <okapi_at_yahoo.com> wrote in message news:f12cd3d1.0410271142.77ddc802_at_posting.google.com...
> I'm trying to update an application to support both Oracle 9 (and 10)
> and MySQL 4.1 and the one area of compatibility that is problematic
> for me is dates and date math (like sysdate - 1 is yesterday). Does
> Oracle support more ANSI compatible date to use instead of sysdate and
> sysdate +/- days?
>
> Thanks,
> Steve

Example please?

If you use stored procs then you won't have this problem since all the logic is just a function call into the database. Jim Received on Wed Oct 27 2004 - 20:08:27 CDT