Some additional information from my experiments:
When I use Criteria API to select rows basing on LastModified e.g.
...Expression.Gt("LastModified",
myTimestamp)
then it works fine on Oracle (1 ms precision is available) but fails on SQL
Server (i can't get below 3 ms precision)
If I change queries to HQL and use query.SetDateTime2("myTimestamp",
myTimestamp) then it works fine on SQL Server (1 ms precision is
available), but fails on Oracle (ArgumentException when preparing query)
If I use query.SetTimestamp(...) then it works fine on Oracle, but on SQL
Server still does not allow to get less than 3 ms precision.
Bartek
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.