Re: Oracle 9 / MySQL date compatibility

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 28 Oct 2004 09:15:01 +0200
Message-ID: <clq69m$a4q$1@news.BelWue.DE>

Jim Kennedy wrote:
> "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
>
>

Hehehe, good one :-). Stored Procs in MySQL 4.1! They were only invented recently with Version 5.0, at least that's what their docu says.

Cheers,
Holger Received on Thu Oct 28 2004 - 02:15:01 CDT