RE: select question (again)

2003-12-18 Thread Hennebelle
Hi, personnally, I put : criteria.addSql(date = TO_DATE('2004', '')); But I think there other possibilities -Message d'origine- De : Glauber Andrade [mailto:[EMAIL PROTECTED] Envoyé : jeudi 18 décembre 2003 00:19 À : OJB Users List Objet : select question (again) How do I implement

Re: select question (again)

2003-12-18 Thread Martin Kalén
Hennebelle wrote: personnally, I put : criteria.addSql(date = TO_DATE('2004', '')); There's also: criteria.addEqualTo(date, TO_DATE('2004', '')); Works similar with all operators/'add'-methods on a Criteria. Regards, Martin -- Martin Kalén Curalia AB Web:

RE: select question (again)

2003-12-18 Thread Brian McCallister
: Re: select question (again) Hennebelle wrote: personnally, I put : criteria.addSql(date = TO_DATE('2004', '')); There's also: criteria.addEqualTo(date, TO_DATE('2004', '')); Works similar with all operators/'add'-methods on a Criteria. Regards, Martin

select question (again)

2003-12-17 Thread Glauber Andrade
How do I implement a select like this with OJB Criteria ? select * from TABLE where date = TO_DATE('2004','') (as on Oracle) or select * from TABLE where YEAR(date) = 2004 (as on MySQL) THANKS, Glauber Andrade