Hallo!

Is it possible to use MONTH in a CreateCriteria-statement?

Does NHibernate support YEAR and/or MONTH?

I have a sql-statement like
select obs2.Lopnr from Obs obs2 where MONTH(obs2.Datum)=11)

Best Regards from

Mats

Hello again!

I tried this and it works fine for me:

ICriteria crit = CurrentSession.CreateCriteria(typeof(Obs), "obs") .Add(Expression.Sql("MONTH({alias}.ObsDatum)=?", 11, NHibernateUtil.Int32));

IList<Obs> list = crit.List<Obs>();

// Mats