Hibernate Community • View topic - Using Order in Criteria to sort Date without time

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Using Order in Criteria to sort Date without time

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

alexuyus@yahoo.com

Post subject: Using Order in Criteria to sort Date without time

Posted: Thu Jan 15, 2015 3:08 pm

Newbie

Joined: Thu Jan 15, 2015 2:58 pm
Posts: 1

Hi

In my DB I have a Requested by field that contains a date with time and a priority field (that is an integer)

i need to sort by Requested by without time and then priority. Is there a way to do this using Criteria ?

eg

criteria.addOrder(Order.asc("reqdate")); //But it should sort without the time component
criteria.addOrder(Order.asc("prioritycode"));

I need to remove the time in the Requested by sorting or else a record with Jan 1 1:00 pm Priority 3 would come before Jan 1 3:00 PM Priority 1
Ideally it should sort by Jan 1 only then by priority.

Top

astafev

Post subject: Re: Using Order in Criteria to sort Date without time

Posted: Fri Jan 16, 2015 4:06 am

Newbie

Joined: Mon Jan 12, 2015 3:56 am
Posts: 5

I would create @Formula field in entity on your place.
I doubt if there are other opportunities without extending base classes.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum