DevForce Community Forum : DateTime issue http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : DateTime issue Wed, 13 May 2026 04:54:56 -700 Thu, 28 Jun 2012 13:36:48 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3504 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ DateTime issue : Sorry, I missunderstood you.... http://www.ideablade.com/forum/forum_posts.asp?TID=3504&PID=13931#13931 Author: mgood
Subject: 3504
Posted: 28-Jun-2012 at 1:36pm

Sorry, I missunderstood you. Both DevForce and Entity Framework use DateTimeKind.Unspecified for any DateTime property, so nothing should mess with it, because there isn't enough information to do any conversion. Are you setting the DateTimeKind yourself to something other than Unspecified?]]> Thu, 28 Jun 2012 13:36:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3504&PID=13931#13931 DateTime issue : Hi,Thanks for the info..However,... http://www.ideablade.com/forum/forum_posts.asp?TID=3504&PID=13926#13926 Author: Vonzkie
Subject: 3504
Posted: 28-Jun-2012 at 2:22am

Hi,

Thanks for the info..
However, I'm having hard time understanding this.. 
Our requirement is just simple, regardless of the timezone between client and server, we want to save and retrieve the date value in the way we entered it.

Thanks,
Von
]]> Thu, 28 Jun 2012 02:22:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3504&PID=13926#13926 DateTime issue : If your application deals with... http://www.ideablade.com/forum/forum_posts.asp?TID=3504&PID=13885#13885 Author: mgood
Subject: 3504
Posted: 21-Jun-2012 at 11:01am

If your application deals with multiple timezones you should store dates and times relative to Coordinated Universal Time (UTC) and then convert them to local time and back on the client. The easiest way to do that is by using DateTimeOffset instead of DateTime. DateTimeOffset represents a point in time relative to UTC and has all the conversion logic built-in to get the local time through the LocalDateTime property. 

If you can't change your data model to use DateTimeOffset, then you should do the conversion yourself and always store data time in UTC. The following post has some useful information regarding this topic.

http://stackoverflow.com/questions/246498/creating-a-datetime-in-a-specific-time-zone-in-c-sharp-fx-3-5
]]> Thu, 21 Jun 2012 11:01:22 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3504&PID=13885#13885 DateTime issue : Hi,We have a problem in our application... http://www.ideablade.com/forum/forum_posts.asp?TID=3504&PID=13884#13884 Author: Vonzkie
Subject: 3504
Posted: 21-Jun-2012 at 3:47am

Hi,

We have a problem in our application that if our client end has a timezone different to the server's timezone the date is converted to the database.

How can we eliminate that by applying fixes to all datetime values without applying it to each field of each entity?

BTW, we're using Database First approach.

Thanks,
Von
]]> Thu, 21 Jun 2012 03:47:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3504&PID=13884#13884