In SQL Server 2008, An instance of DateTimeOffset type can represent: 1) A local time + a time zone offset 2) A UTC time + a time zone offset 3) A local time and a UTC time. When converting such an instance to other date and time types, such as datetime
Read More...