.net6.0的datetime在PostgreSQL，timestamp with time zone

最新推荐文章于 2024-07-10 11:45:31 发布

大聪

最新推荐文章于 2024-07-10 11:45:31 发布

阅读量3.6k

点赞数 2

分类专栏： postgresql 文章标签： .net postgresql microsoft

本文链接：https://blog.csdn.net/dacong/article/details/122674892

版权

postgresql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

---> System.InvalidCastException: Cannot write DateTime with Kind=Local to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.

abp5.1.2使用PostgreSQL问题，

Cannot write DateTime with Kind=UTC to PostgreSQL type 'timestamp without time zone'

main函数中增加

AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true);
AppContext.SetSwitch("Npgsql.DisableDateTimeInfinityConversions", true);

await CreateHostBuilder(args).RunConsoleAsync();

... //adding services etc
var host = builder.Build();
AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true);
... //your other scoped code
await host.RunAsync();