Hi all, I've an issue querying a Mysql 5 database with NHibernate.

My query looks like this:

ICriteria criteria =
Session.CreateCriteria(typeof(Voucher))
.AddOrder(Order.Asc("Title"))
.AddOrder(Order.Desc("StartDate"))
.Add(Restrictions.Gt("EndDate", DateTime.Now))
.Add(Restrictions.Lt("StartDate", DateTime.Now))
.SetFirstResult(firstResult)
.SetMaxResults(maxResults);

return criteria.List<Voucher>();

Running a test, the SQL looks like this:

NHibernate: SELECT ... FROM Voucher this_ WHERE this_.EndDate > ?p0 and this_.StartDate < ?p1 ORDER BY this_.Title asc, this_.StartDate desc limit ?p2;?p0 = 07/08/2009 10:53:42, ?p1 = 07/08/2009 10:53:42, ?p2 = 2

On the database unfortunately, the datetime fields are stored with this format: 2009-02-09 06:00:00

Nothing gets found, am I missing something?

Thanks in advance.

Sorry, my test was simply wrong, it works, I guess MySQL handles the conversion between different datetime formats.

I'm very interested! I would love to find out more inforamtion related to this topic. Thanks in advance.
me too, I need more detailed info


comparatif simulation taux pret auto - taux pret auto differe selon la prise en compte ... calculent automatiquement le taux pour un prêt automobile donne.comparatif simulation taux pret auto