Hibernate Community • View topic - How to compare DateTime in NHibernate

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

How to compare DateTime in NHibernate

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

texudo

Post subject: How to compare DateTime in NHibernate

Posted: Wed Aug 23, 2006 6:39 am

Newbie

Joined: Tue Jul 18, 2006 2:29 pm
Posts: 10

I have a HQL:

string hql ="Select schedule.ScheduleId From TblSchedule as schedule Where schedule.Classroom.ClassroomId = " + intClassRoomID +" and schedule.StartTime <='" + startime + "'";

How can I compare the field DataTime??
I need change startime to string with format similiar in SQL Server ("YYYYMMDDD")??

Thanks for answers.

Top

sergey

Post subject:

Posted: Wed Aug 23, 2006 8:00 am

Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic

Use parameters, don't concatenate data into HQL directly.

Code:

session.CreateQuery("select ... where schedule.StartTime < ?").SetDate(0, startTime).List();

Top

texudo

Post subject: Thanks Sergey

Posted: Wed Aug 23, 2006 12:35 pm

Newbie

Joined: Tue Jul 18, 2006 2:29 pm
Posts: 10

It's good solution.
I'm often use HQL with directly parameter....it's ugly....
Thanks sergey for your answer.

Top

texudo

Post subject: Thanks Sergey

Posted: Wed Aug 23, 2006 12:36 pm

Newbie

Joined: Tue Jul 18, 2006 2:29 pm
Posts: 10

It's good solution.
Before , I'm often use HQL with directly parameter.......
Thanks sergey for your answer.

Top

Page 1 of 1

[ 4 posts ]

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