Question

Currently I'm using DateTime (with UTC) to store all dates - experience has taught me always to use UTC for any date time values.

I'd like to use DateTimeOffset because it stores in UTC and also has the timezone offset - but this isn't supported as a built-in type.

What is the best way of achieving this. Should I simply encapsulate DateTimeOffset in a wrapper class that derivces from entity

Accepted Answer

Hello Richard,

Unfortunately, DateTimeOffset type is not yet supported. In order to store DateTime values with UTC I could recommend to try the following pattern:

class MyEntity : Entity {

  [Field]  // Persistent field
  private DateTime DateTimePart { get; set; }

  [Field]  // Persistent field
  private TimeSpan TimeSpanPart { get; set; }

  // Non persistent field
  public DateTimeOffset UTCDate {
    get { return new DateTimeOffset(DateTimePart, TimeSpanPart); }
    set {
      DateTimePart = value.DateTime;
      TimeSpanPart = value.Offset;
    }
  }
}

Hope that helps. Support for DateTimeOffset might appear in the future versions.

Subscription:

Related questions