3
Shouts

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

published 646 days, 11 hours, 53 minutes ago posted by http://troyhunt.myopenid.com/http://troyhunt.myopenid.com/ 648 days, 22 hours, 9 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Wednesday, August 10, 2011 11:03:31 AM GMT

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.

category: Web Dev | clicked: 11 | | source: www.troyhunt.com | show counter code
tags: .NET, SQL

No comments yet, be the first one to post comment.

To post your comment please login or signup