Re: problem with date in oracle 10g

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