Depending on your database and usage, another option is to set up a view and let the database create derived columns for these, then you can treat them as regular Cayenne data object fields.
2012/3/14 Emerson Castañeda <[email protected]>: > 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
