Hi,

I'm trying to write a very simple query like:

select o.Date.Value.Month from Order o

The Date property is a NullableDateTime, however, in the database, it actually never is null. I'm getting a deferenced error when executing this query.

Is the problem related with the fact that Value and Month are properties that don't appear in the mapping file?

Thanks,
Nuno

Yes.

HQL doesn't work by magic, it works by being translated to SQL, so try using some SQL function to get the month value from a date.