Databases
StackOverflow2013
Postsdbo
PODateTime.ToLocalTime() behavior change with .NET 4.5 on Server 2008R2?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODateTime.ToLocalTime() behavior change with .NET 4.5 on Server 2008R2?
    primarykey
    data
    text
    <p>We are seeing bizarre behavior with .NET 4.5 and System.DateTime. The behavior of ToLocalTime() when applied to DateTime objects with Kind=Utc seems different on Server 2008R2 machines with .NET 4.5 compared with .NET 4.0. Even more bizarre, the problem does not manifest on developer PCs with .NET 4.5 installed.</p> <p>Does anyone have an explanation for this behavior? I can't turn up any bug reports on Microsoft sites. We can use a more complicated approach to convert times that works, but it's hard to ensure no one ever uses .ToLocalTime() in the future.</p> <p>Developer PC - Windows 7, VS2012, .NET 4.5 installed during VS2012 install:</p> <pre><code>unixEpoch 621355968000000000 Utc asLocal1 635121441023588986 Local asLocal2 635121441023588986 Unspecified </code></pre> <p>Production Server 1 - Server 2008R2, .NET 4.0</p> <pre><code>unixEpoch 621355968000000000 Utc asLocal1 635121441023588986 Local asLocal2 635121441023588986 Unspecified </code></pre> <p>Production Server 2 - Server 2008R2, .NET 4.5 installed as standalone package</p> <pre><code>unixEpoch 621355968000000000 Utc asLocal1 ***635121405023588986*** Local asLocal2 635121441023588986 Unspecified </code></pre> <p>Other than having .NET 4.5 installed, production servers 1 and 2 are identical. The problem manifests when run in several different local timezones around the globe.</p> <p>Sample code that demonstrates the problem:</p> <pre><code>using System; using NUnit.Framework; namespace DateTimeToLocal { [TestFixture] public class DateTimeFixture { private const long unixTimeInNanos = 1376561702358898611; [Test] public void Demonstrate() { DateTime unixEpoch = new DateTime(1970, 01, 01, 0, 0, 0, DateTimeKind.Utc); DateTime utc = unixEpoch.AddTicks(unixTimeInNanos / 100); // Method 1 - doesn't work on 2008R2 with .NET 4.5 DateTime asLocal1 = utc.ToLocalTime(); // Method 2 - works across all .NET 4.0 and .NET 4.5 TimeZoneInfo localTz = TimeZoneInfo.FindSystemTimeZoneById(TimeZoneInfo.Local.StandardName); DateTime asLocal2 = TimeZoneInfo.ConvertTimeFromUtc(utc, localTz); Console.WriteLine("unixEpoch {0} {1}", unixEpoch.Ticks,unixEpoch.Kind); Console.WriteLine("asLocal1 {0} {1}", asLocal1.Ticks, asLocal1.Kind); Console.WriteLine("asLocal2 {0} {1}", asLocal2.Ticks, asLocal2.Kind); Assert.AreEqual(asLocal1, asLocal2); } public static void Main(string[] args) { var t = new DateTimeFixture(); t.Demonstrate(); } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBrian Reischl
    1. USDave Moore
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODateTime.ToLocalTime() behavior change with .NET 4.5 on Server 2008R2?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODateTime.ToLocalTime() behavior change with .NET 4.5 on Server 2008R2?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PODateTime.ToLocalTime() behavior change with .NET 4.5 on Server 2008R2?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAre you getting bitten by daylight savings time (being calculated for Local but not for Unspecified)?
      singulars
      1. PODateTime.ToLocalTime() behavior change with .NET 4.5 on Server 2008R2?
      1. USScott Chamberlain
    2. COpossible duplicate of [TimeZoneInfo.Local vs TimeZoneInfo.FindSystemTimeZoneById](http://stackoverflow.com/questions/14861302/timezoneinfo-local-vs-timezoneinfo-findsystemtimezonebyid)
      singulars
      1. PODateTime.ToLocalTime() behavior change with .NET 4.5 on Server 2008R2?
      1. USBartoszKP
    3. COWhat is `GetUtcOffset` returning for each of these cases? http://msdn.microsoft.com/en-us/library/system.timezone.getutcoffset.aspx
      singulars
      1. PODateTime.ToLocalTime() behavior change with .NET 4.5 on Server 2008R2?
      1. USEkoostikMartin
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload