Re: Ordering by date on a timestamp field

2016-06-09 Thread Andrus Adamchik
ike 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 Modele

Re: Ordering by date on a timestamp field

2016-06-09 Thread Frank Herrmann
ably 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 > >> > >>

Re: Ordering by date on a timestamp field

2016-06-09 Thread Hugi Thordarson
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.

Re: Ordering by date on a timestamp field

2016-06-09 Thread Andrus Adamchik
Unfortunately you can't do that with ObjectSelect. SQLSelect of course would allow to use MySQL functions. So that's probably the way to go here. Andrus > On Jun 8, 2016, at 11:07 PM, Frank Herrmann > wrote: > > Hello all, > > Is there a way in