datetimeoffset – Tarik Billa

Convert UTC DateTime to DateTimeOffset

November 29, 2023 by Tarik

Here is the solution you are looking for: const string dateString = “2012-11-20T00:00:00Z”; TimeZoneInfo timezone = TimeZoneInfo.FindSystemTimeZoneById(“W. Europe Standard Time”); //this timezone has an offset of +01:00:00 on this date DateTimeOffset utc = DateTimeOffset.Parse(dateString); DateTimeOffset result = TimeZoneInfo.ConvertTime(utc, timezone); Assert.AreEqual(result.Offset, new TimeSpan(1, 0, 0)); //the correct utc offset, in this case +01:00:00 Assert.AreEqual(result.UtcDateTime, new DateTime(2012, … Read more

The UTC time represented when the offset is applied must be between year 0 and 10,000. Parameter name: offset

August 20, 2023 by Tarik

The DateTimeOffset constructor first converts any DateTime that is not of Kind ‘UTC’ to the equivalent UTC time. It will then check whether the UTC-equivalent DateTime falls outside of the bounds of DateTimeOffset.MinValue and DateTimeOffset.MaxValue, and if it does, will throw an ArgumentOutOfRangeException similar to the one you are experiencing. Check the DateTime.Kind of the … Read more

Difference between ‘DateTime’ and ‘DateTimeOffset’ [duplicate]

July 16, 2023 by Tarik

DateTimeOffset Represents a point in time, typically expressed as a date and time of day, relative to Coordinated Universal Time (UTC) it provides a greater degree of time zone awareness than the DateTime structure. See it here- http://msdn.microsoft.com/en-us/library/bb546101.aspx.

Why does Json.NET DeserializeObject change the timezone to local time?

April 21, 2023 by Tarik

It seems to be ignoring DateParseHandling.DateTimeOffset and is using DateParseHandling.DateTime. I would log an issue here: https://github.com/JamesNK/Newtonsoft.Json

When Would You Prefer DateTime Over DateTimeOffset

April 9, 2023 by Tarik

Sometimes you really just want to represent a “local” (timezone unaware) date and time rather than an instant in time. To be honest it’s more often useful to represent just a time – e.g. “wake me up at 8am, regardless of timezone” – but date and time could be useful too. I agree that for … Read more

Convert DateTimeOffset to DateTime and add offset to this DateTime

March 19, 2023 by Tarik

Use DateTimeOffset.UtcDateTime: DateTime utc = myDTO.UtcDateTime; // 01/15/2015 22:37:00

How can I convert a Sql Server 2008 DateTimeOffset to a DateTime

February 23, 2023 by Tarik

Converting using almost any style will cause the datetime2 value to be converted to UTC. Also, conversion from datetime2 to datetimeoffset simply sets the offset at +00:00, per the below, so it is a quick way to convert from Datetimeoffset(offset!=0) to Datetimeoffset(+00:00) declare @createdon datetimeoffset set @createdon = ‘2008-12-19 17:30:09.1234567 +11:00’ select CONVERT(datetime2, @createdon, 1) … Read more

Determine Whether Daylight Savings Time (DST) is Active in Java for a Specified Date

February 19, 2023 by Tarik

This is the answer for the machine on which the question is being asked: TimeZone.getDefault().inDaylightTime( new Date() ); A server trying to figure this out for a client will need the client’s time zone. See @Powerlord answer for the reason why. For any particular TimeZone TimeZone.getTimeZone( “US/Alaska”).inDaylightTime( new Date() );

Best practices with saving datetime & timezone info in database when data is dependant on datetime

January 25, 2023 by Tarik

Hugo’s answer is mostly correct, but I’ll add a few key points: When you’re storing the customer’s time zone, do NOT store a numerical offset. As others have pointed out, the offset from UTC is only for a single point in time, and can easily change for DST and for other reasons. Instead, you should … Read more

How to use TimeZoneInfo to get local time during Daylight Saving Time?

January 22, 2023 by Tarik

You can also use TimeZoneInfo.ConvertTimeFromUtc, which will allow for daylight saving time: DateTime utc = DateTime.UtcNow; TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById(“Central Standard Time”); DateTime localDateTime = TimeZoneInfo.ConvertTimeFromUtc(utc, zone);