Date/Time Support in NHibernate

In this post, we’ll examine the ways that NHibernate supports the DateTime-related data types, including some new features introduced in NHibernate 2 and 3. Here is a quick summary for the impatient.

DbType	.NET	SQL Type
DateTime	System.DateTime	datetime
LocalDateTime	System.DateTime	datetime
UtcDateTime	System.DateTime	datetime
DateTimeOffset	System.DateTimeOffset	datetimeoffset
DateTime2	System.DateTime	datetime2
Date	System.DateTime	date
Time	System.DateTime	time
TimeAsTimeSpan	System.TimeSpan	time
TimeSpan	System.TimeSpan	bigint (int64)

Let’s take a look at a few DateTime-related problems that developers have run into in the past…

Read more: James Kovacs' Weblog

Posted via email from Jasper-Net