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
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)
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
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