I am having a problem compairing dates with NHibernate:

For example i have this named query



I have a date stored in my db 08/03/2006 (which is in the United Kingdom ddmmyyyy format) but when is compare this with the current shortdatetime Derived from System.DateTime.Now.ToShortDateString(); which is 09/03/2006 also in ddmmyyyy.

"starting_date <= ?" nhibernate Is evaluating this to false and it only appears to evaluate to ture when i change the stored start date to 03/09/2006 so i appear hibernate is converting it to us style.

How do i fix this?

Anyone got any help with this?

What is the DB field type of affected fields?
And Are You assigning string or date value to the parameter? If string, try converting it to date and assign converted value to param.

Gert

I use queries with named params, then assign UK dates (e.g. -

IQuery q = CurrentSession.CreateQuery(queryToExecute);

//add the date params
q.SetParameter("StartDate",StartDate);
q.SetParameter("EndDate",EndDate);
)
I've never had any problems. Are you using datetime variables, or are you parsing strings?

Mark

Yes, named parameters work much better for dates, in my experience.