How do I implement a select like this with OJB Criteria ?

select * from <TABLE> where date = TO_DATE('2004','yyyy')             (as on
Oracle)
or
select * from <TABLE> where YEAR(date) = 2004
(as on MySQL)

THANKS,

Glauber Andrade



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to