Hibernate Community • View topic - How to get year from a date field

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to get year from a date field

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

arthur_info

Post subject: How to get year from a date field

Posted: Fri Feb 18, 2011 3:18 pm

Newbie

Joined: Fri Feb 18, 2011 3:04 pm
Posts: 2

Hello,

I've got a entity named "pj" and I want to extract only the year of one field and get all the years on a list. How to do that using detachedcriteria? I'm using postgre. See the sql:

Code:

select extract(year from pj.dt_criacao) as year
from tb_pj pj
group by extract(year from pj.dt_criacao)
order by year desc

I was starting using this...

Code:

DetachedCriteria criteria = DetachedCriteria.forClass(Pj.class, "pj");
criteria.setProjection(Projections.groupProperty("extract(year from dt_criacao)")); --> from this point I don't know how to do...
List<Integer> lista = getDao().getEntityManager().findByCriteria(criteria);

Thanks a lot

Top

arthur_info

Post subject: Re: How to get year from a date field

Posted: Tue Feb 22, 2011 3:46 pm