How to use the formula property in NHibernate mapping

I have a question regarding how to use the formula property to be used in the SQL where clause. Sepcifically, I'd like to use (datepart(hh, getdate())) as the formula and the res开发者_Python百科ulting SQL that I expect is

Select select_list from table_name where (datepart(hh, getdate())) < 17

But I kept the where clause like this:

where (this_0_.hh, getdate())) <= 17

I am not sure why the alias is inserted before the "hh" date part.

Any help on how to get this where clause right is highly appreciated!

Thanks.

---

The alias is inserted because the parser doesn't know hh is a literal (if MS had used a string, you wouldn't have this problem, as you'd be able to use 'hh' without a problem)

The easiest workaround is creating a function (call it gethour) that returns datepart(hh, getdate()).