❔ PostgreSQL DateTime in EF Core

So I have an app that uses EF Core with Npgsql that runs locally and I want to connect to a postgresql database which runs in a docker container. The connection and adding stuff works and all, but when I wanna save my changes, then I get this error

Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported.

Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported.

. Googling didn't really yield any valuable answers either fluffyFoxThink

. So my columns are in the picture and my model is this. Any idea how to handle

DateTime?

DateTime?

in this context?

public sealed class MyModel
{
    [DataType(DataType.DateTime)]
    public DateTime? Start { get; set; }

    [DataType(DataType.DateTime)]
    public DateTime? End { get; set; }
}

public sealed class MyModel
{
    [DataType(DataType.DateTime)]
    public DateTime? Start { get; set; }

    [DataType(DataType.DateTime)]
    public DateTime? End { get; set; }
}

C#•4y ago•

42 replies

HimmDawg

❔ PostgreSQL DateTime in EF Core

Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported.

Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported.

. Googling didn't really yield any valuable answers either fluffyFoxThink

. So my columns are in the picture and my model is this. Any idea how to handle

DateTime?

DateTime?

in this context?

public sealed class MyModel
{
    [DataType(DataType.DateTime)]
    public DateTime? Start { get; set; }

    [DataType(DataType.DateTime)]
    public DateTime? End { get; set; }
}

public sealed class MyModel
{
    [DataType(DataType.DateTime)]
    public DateTime? Start { get; set; }

    [DataType(DataType.DateTime)]
    public DateTime? End { get; set; }
}

❔ PostgreSQL DateTime in EF Core

Similar Threads

❔ PostgreSQL DateTime in EF Core

Similar Threads

Similar Threads

Similar Threads