Re: Oracle 9 / MySQL date compatibility

"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:clq69m$a4q$1_at_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

Do they already have foreign keys ? ;-)

Matthias Received on Thu Oct 28 2004 - 14:17:55 CDT