topic Re: Problem related dates. SDK changes dates to -3 hours everytime in .NET Maps SDK Questions

Problem related dates. SDK changes dates to -3 hours everytime

MarkoKangas — Mon, 20 Apr 2015 13:34:49 GMT

I have problem related datetime. If I try to save date to 20.4.2015 0:00:00 it goes to database 19.04.2015.21:00:00.

Somehow SDK changes datetime to -3 hour. (My timezone is +3h to UTC)

Where I can change this behaviour? Any tips?

dotMorten_esri — Mon, 20 Apr 2015 21:08:51 GMT

The database uses UTC so that sounds about right. You can convert DateTime objects between UTC and Local using the .NET Datetime API.

Also make sure you specify the DateTime.Kind correctly when creating the DateTime object.

MarkoKangas — Tue, 21 Apr 2015 05:05:46 GMT

Okay I ask this more detailed. So Esri SDK makes all date values to UTC datetime. Why SDK doesn't convert those values back to related timezone?

Example I save value (UI) : 1.1.2000 0:00 GMT+3 -> Database its 31.12.1999 21:00 (Problem is bigger if DB field is on DATE)

Why SDK returns that 31.12.1999 21:00 not 1.1.2000 ?

dotMorten_esri — Tue, 21 Apr 2015 05:18:24 GMT

31.12.1999 21:00 UTC is the exact same date as 01.01.2000 00:00 GMT+3.

It's the job of the app you build do input and output dates in the appropriate time zone for that app.

This is just how .NET handles dates - The Runtime ensures time zones doesn't cause dates across timezones to get mixed up by always saving in UTC.

MarkoKangas — Tue, 21 Apr 2015 05:20:48 GMT

Okay -> Esri SDK default behaviour to unspecified Kind is UTC. Thats good to know