Hibernate Community • View topic - GROUP BY DATE with a DateTime field

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

GROUP BY DATE with a DateTime field

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

p303

Post subject: GROUP BY DATE with a DateTime field

Posted: Wed May 07, 2008 4:44 am

Newbie

Joined: Wed May 07, 2008 4:39 am
Posts: 3

Hi,

I have a table with records that contains a datetime field. I want to retrieve the average number of records per day.

I could do this:

Code:

IList results = session.CreateCriteria(typeof(Cat))
                    .SetProjection(Projections.ProjectionList()
                    .Add(Projections.RowCount(), "AverageRecordsPerDay")
                    .Add(Projections.GroupProperty("RecordDate"), "date")
                )
                .List();

But this will do the grouping on DATE & TIME part of the field and not only the DATE part of the field.

Any idea?

Thanks a lot

Top

ferozz

Post subject:

Posted: Wed May 07, 2008 5:00 am

Regular

Joined: Mon Aug 06, 2007 10:49 am
Posts: 67
Location: Banska Bystrica, Slovakia

u can try to map that column once again as Date property with insert,update = false, and using formula=sqlFunctionToConvertDatetime2Date(RecordDate) (use some db function here) and try to use group by on this property

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