DateTime precision in NHibernate and support for DateTime2 in NHibernate SchemeExport

by

Actually the NHibernate reference states that the DateTime nhibernate type will store the .NET DateTime as an SQL datetime truncated at the second level (no millisecond granularity)

As such it provides the Timestamp NHibernate type (type="Timestamp" in the mapping) which will store a .NET DateTime as an SQL datetime without truncation. Note here that an SQL timestamp datatype is not needed and will infact break if you have more than one timestamp column in one table. It’s thus important to differentiate between the sql-type and type attributes in the NHibernate mapping.

Additionally, note that if you are working with filters, the same rule applies at the filter definition: If you specify a DateTime parameter, the parameter’s value will be truncated without milliseconds.

Check out chapter 5.2.2. Basic value types, Table 5.3 System.ValueType Mapping Types.

More Related Contents:

  1. How do you map an enum as an int value with fluent NHibernate?
  2. IndexOutOfRangeException Deep in the bowels of NHibernate
  3. Unable to cast object of type NHibernate.Collection.Generic.PersistentGenericBag to List
  4. Binary Blob truncated to 8000 bytes – SQL Server 2008 / varbinary(max)
  5. NHibernate configuration for uni-directional one-to-many relation
  6. Generate XML mappings from fluent Nhibernate
  7. How do add NOLOCK with nHibernate?
  8. Syntax to define a NHibernate Filter with Fluent Nhibernate?
  9. Display which day it is? sunday or monday “php coding”? [closed]
  10. How do you get a timestamp in JavaScript?
  11. Convert timestamps with offset to datetime obj using strptime
  12. How to Eager Load Associations without duplication in NHibernate?
  13. Convert Date/Time for given Timezone – java
  14. Nhibernate: How to represent Many-To-Many relationships with One-to-Many relationships?
  15. How to convert integer timestamp to Python datetime
  16. What are the First and Second Level caches in (N)Hibernate?
  17. How to convert integer timestamp into a datetime
  18. MySQL convert date string to Unix timestamp
  19. Convert datetime to Unix timestamp and convert it back in python
  20. Inverse Attribute in NHibernate
  21. How can I have NHibernate only generate the SQL without executing it?
  22. Convert .NET Ticks to SQL Server DateTime
  23. In Ruby on Rails, what’s the difference between DateTime, Timestamp, Time and Date?
  24. How to convert a unix timestamp (seconds since epoch) to Ruby DateTime?
  25. How can I keep the original file [commit] timestamp on Subversion?
  26. Python UTC datetime object’s ISO format doesn’t include Z (Zulu or Zero offset)
  27. How to create OR statements for NHibernate?
  28. NHibernate: difference between Interceptor and Listener
  29. What exactly is “persistence ignorance”?
  30. Programming to interfaces while mapping with Fluent NHibernate

Leave a Comment