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.
|
3
Shouts |
|
|||
No comments yet, be the first one to post comment.