I can't speak to what Cayenne is able to do solely when using an ObjectQuery, but from a database perspective it sounds like you want to be using a view that provides the date-only version of your datetime column. Then you could query it just like a table and do your sort on the date-only column. You can probably use the Query object type in your project model to achieve this if you aren't keen on adding SQL objects to your model outside of Cayenne Modeler.
-Adam ________________________________ From: Frank Herrmann <frank.herrm...@modernizingmedicine.com> Sent: Wednesday, June 8, 2016 4:07:44 PM To: user@cayenne.apache.org Subject: Ordering by date on a timestamp field Hello all, Is there a way in Cayenne, when adding an ordering to a query, to order by only the date portion of a timestamp (including time) field? Basically, the timestamp includes hour, minutes, seconds, etc. I only want to sort on the date portion (month, day, year), or any other such criteria. The reason for this is, if we include other fields to sort by, we would want the second sort field to group on the date, not the full timestamp. Thanks, -Frank -- FRANK HERRMANN SOFTWARE ENGINEER T: 561-880-2998 x1563 E: frank.herrm...@modmed.com [image: [ Modernizing Medicine ]] <http://www.modmed.com/> [image: [ Facebook ]] <http://www.facebook.com/modernizingmedicine> [image: [ LinkedIn ]] <http://www.linkedin.com/company/modernizing-medicine/> [image: [ YouTube ]] <http://www.youtube.com/user/modernizingmedicine> [image: [ Twitter ]] <https://twitter.com/modmed_EMA> [image: [ Blog ]] <http://www.modmed.com/BlogBeyondEMR> [image: [ Instagram ]] <http://instagram.com/modernizing_medicine>
