Re: Ordering by date on a timestamp field

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

Re: Ordering by date on a timestamp field

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

Re: Ordering by date on a timestamp field

2016-06-09 Thread Hugi Thordarson
n adding SQL objects to your model outside >> of Cayenne Modeler. >> >> >> -Adam >> >> ____ >> From: Frank Herrmann >> Sent: Wednesday, June 8, 2016 4:07:44 PM >> To: user@cayenne.apache.org >> Subject: Orderin

Re: Ordering by date on a timestamp field

2016-06-08 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 Cayenne, when adding an ordering to a query, to

Re: Ordering by date on a timestamp field

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

Re: Ordering by date on a timestamp field

2016-06-08 Thread Adam Boyle
M 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 da

Ordering by date on a timestamp field

2016-06-08 Thread Frank Herrmann
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.