Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem with date in oracle 10g

Re: problem with date in oracle 10g

From: Jeroen van den Broek <nltaal_at_baasbovenbaas.demon.nl>
Date: Wed, 19 Dec 2007 07:20:44 -0800 (PST)
Message-ID: <092983c4-db6c-4194-be49-fea0b8a4ac9e@b1g2000pra.googlegroups.com>


On Dec 19, 10:58 am, "Roberto Nenni" <rnen..._at_xeim.it> wrote:
> <fitzjarr..._at_cox.net> ha scritto nel messaggionews:42663ad9-4e3f-41ef-b35d-79e322d7c7e5_at_r60g2000hsc.googlegroups.com...> On Dec 18, 1:30 pm, "Roberto Nenni" <rnen..._at_xeim.it> wrote:
> > Why are you trying to recreate the wheel? The LEAST() function has
> > been around since at least 8.1.6:
>
> because my queries must run with Oracle, db2, SqlServer so i have to do some
> functions that work with all of them
>
> many thank in any case, i learn something today
>
> by
> roberto

I don't know about MS SqlServer, but for DB2 IBM provides a lot of UDF's targeted at customers that want to migrate to DB2 from Oracle or Sybase. May be you can use them for your portability purpose as well (although in general I would say it is better to use each DBMS's intrinsic features). Have a look here, where you will find UDF's for LEAST/GREATEST among many others:
http://www.ibm.com/developerworks/db2/library/samples/db2/0205udfs/index.html

HTH

--
Jeroen
Received on Wed Dec 19 2007 - 09:20:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US