Re: problem with date in oracle 10g

From: Jerome Vitalis <vitalismanN0SP4M_at_gmail.com.invalid>
Date: Tue, 18 Dec 2007 20:52:35 +0100
Message-ID: <476824f8$0$953$79c14f64@nan-newsreader-07.noos.net>

Roberto Nenni wrote:

> i use it in a query like this:
> select field,field
> ,whr_dtMax(a.dtiniz,c.dtinmeCo) dtiniz
> ,whr_dtMin(a.dtfine,c.dtfimeCo) dtfine
> ,field,field
> from tablea a
> join tablec c etc...
>
> can anybody help me?

It might be caused by some implicit data type conversion. Please post the result of "desc <tablename>" for the tables involved. And an actual example of the query when its result is incorrect. Received on Tue Dec 18 2007 - 13:52:35 CST