Hibernate Community • View topic - Problem with min(Type.DateTime)

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Problem with min(Type.DateTime)

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

echoSwe

Post subject: Problem with min(Type.DateTime)

Posted: Wed Nov 22, 2006 11:07 am

Beginner

Joined: Thu Oct 19, 2006 1:03 pm
Posts: 29

I'm having trouble getting this HQL-query to return an object, a DateTime.

Code:

IQuery q = session.CreateQuery("select min(o.Date) from AssemblyName.TheObject o");
DateTime dt = (DateTime)q.UniqueResult();

Returns all TheObject-s in the table.

That's what I'd like. This also doesn't work:

Code:

IQuery q = session.CreateQuery("select year(min(o.Date)) from AssemblyName.TheObject o");
int inter = (int)q.UniqueResult();

Could someone please test this out?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » NHibernate 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