Howto Include Time/Date Functions in Query Expressions

[Emerson Castañeda]

HI everyone

I have a table with a timestamp field, so  I'm thinking about how to write
the next query without define a store procedure, but directly from my java
code:

select *
from  table1
where
id = 1 and
extract(day from timestampField)='04' and
extract(month from timestampField)='04' and
extract(year from timestampField)='2009'

I'd like to know if that is possible using cayenne, maybe some thing like
this?


SelectQuery query = new SelectQuery(Table1.class);
query.andQualifier(<??EXPRESSION???>)

OR

SelectQuery query = new SelectQuery(Table1.class);
query.andQualifier( ExpressionFactory.likeIgnoreCaseExp(
                        Table1.timestampproperty, "%"));


Thank you for your time

EMERSON