Overcoming SQL 08’s globally insensitive time zones using .NET

home
asp.net
view story

1 Kicks

Overcoming SQL 08’s globally insensitive time zones using .NET(www.troyhunt.com)

submitted by troyhunt(831) 9 months, 14 days ago

When SQL 08 came along there seemed to be some new hope for making time zone aware apps a little easier through the introduction of a few new date and time related data types, particularly the datetimeoffset type. Unfortunately all that glitters is not gold in this case and the new data type can be a real “gotcha”. Here’s how to build in that geo-awareness from the ground up using the new datetime2 data type and without getting caught with your metaphorical pants down.

add a comment |category: ASP.NET |Views: 0
Tweet