Hi,

One of my mapped properties is a DateTime and when I switched to Firebird (from SQLite), I noticed the following strange behaviour.

If I put a DateTime.MaxValue into this field and let NHibernate save it to the database. It seems to be working, but when I read it out again, it does not have exactly the same value as it had when it was originally saved. The value has changed with a few thousand ticks. However, they are so similar, that they look the same when printed out with a ToString. But still, they are not equal and some of my test cases fail due to this.

I suspect that NHibernate tries convert the native Timestamp Firebird field into ticks, before it converts it back into a DateTime and during this procedure it looses precision.

Is this a known problem with the Firebird dialect?

Best Regards
//Jan Persson