Hi,
Personally I would use
SimpleDateFormat df = new SimpleDateFormat();
criteria.addBetween("date", df.parse("01/01/"+year), df.parse("12/31/"+year));
This makes it database independent.
Wally
-----Original Message-----
From: Martin Kal�n [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 18, 2003 8:00 AM
To: OJB Users List
Subject: Re: select question (again)
Hennebelle wrote:
> personnally, I put :
> criteria.addSql("date = TO_DATE('2004', 'yyyy')");
There's also:
criteria.addEqualTo("date", "TO_DATE('2004', 'yyyy')");
Works similar with all operators/'add'-methods on a Criteria.
Regards,
Martin
--
Martin Kal�n
Curalia AB Web: http://www.curalia.se
Orrspelsv�gen 2B Mail: [EMAIL PROTECTED]
SE-182 79 Stocksund Tel: +46-8-410 064 40
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
