dev-npgsql/npgsql: Npgsql is the .NET data provider for PostgreSQL.

src/Npgsql/Replication/PgDateTime.cs

16 строк611 B

Nino Floris

Handler rework (#5123)

26 сен 2023, 00:08

26 сен 2023, 00:080b7aecb

using System;

namespace Npgsql.Replication;

static class PgDateTime
{
    const long PostgresTimestampOffsetTicks = 630822816000000000L;

    public static DateTime DecodeTimestamp(long value, DateTimeKind kind)
        => new(value * 10 + PostgresTimestampOffsetTicks, kind);

    public static long EncodeTimestamp(DateTime value)
        // Rounding here would cause problems because we would round up DateTime.MaxValue
        // which would make it impossible to retrieve it back from the database, so we just drop the additional precision
        => (value.Ticks - PostgresTimestampOffsetTicks) / 10;
}