Hibernate Community • View topic - Hibernate Criteria- Projections for date

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate Criteria- Projections for date_trunc?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

vsowmyabe

Post subject: Hibernate Criteria- Projections for date_trunc?

Posted: Thu Jun 04, 2009 12:55 pm

Newbie

Joined: Thu Jun 04, 2009 12:51 pm
Posts: 1

Hi,

Iam trying to use Hibernate Criteria Query .I have the following PostgreSQL statement

Select x, date_trunc('month',y) from table

I dont know how to use the projections for date_trunc('month',y) ?

appreciate your help.

Thanks,

Sowmya.

Top

fge

Post subject: Re: Hibernate Criteria- Projections for date_trunc?

Posted: Sun Jun 07, 2009 7:05 am

Beginner

Joined: Mon Jun 01, 2009 5:39 am
Posts: 34

HQL has a month() function.

Maybe a:

Code:

select x, month(y) from table

will do the trick? Not tested.

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