Re: problem with date in oracle 10g

On Dec 19, 4:20 pm, Jeroen van den Broek <nlt..._at_baasbovenbaas.demon.nl> wrote:
> 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/in...
>
> HTH
>

I forgot to mention that version 9.5 of DB2 for LUW delivers the LEAST and GREATEST scalar functions out of the box (like already was the case for DB2 for z/OS since version 7):
https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.wn.doc/doc/c0052946.html

May be an even better source for Oracle/DB2 compatibility is this paper from Serge Rielau:
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0707rielau/

Cheers!

--
Jeroen