Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
MIME-Version: 1.0
From: Frank Herrmann <frank.herrmann@modernizingmedicine.com>
Date: Wed, 8 Jun 2016 16:07:44 -0400
Message-ID: <CAF1JiVT3bqELXez8QrD4V9AqFDOLb1EENtoLQ7KWrrkJgo8uog@mail.gmail.com>
Subject: Ordering by date on a timestamp field
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=001a113d0fc8f254770534c9dc93
archived-at: Wed, 08 Jun 2016 20:08:14 -0000

--001a113d0fc8f254770534c9dc93
Content-Type: text/plain; charset=UTF-8

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.herrmann@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>

--001a113d0fc8f254770534c9dc93--