Be careful doing this in code that which gets executed a lot in a
multi-threaded environment (ie, a servlet container), SDF has some
serious synchronization bottlenecks =/
-Brian
On Thu, 2003-12-18 at 09:29, Gelhar, Wallace Joseph wrote:
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
