System.InvalidCastException: Can’t convert infinite timestamp values to DateTime

System.InvalidCastException: Can’t convert infinite timestamp values to DateTime

I am having a weird issue which seem to be specific to my postgres database on my test server, and not on my local database.

Everytime I insert somerthing to my database I get an error

System.InvalidCastException: Can't convert infinite timestamp values to DateTime

And I cannot seem to understand why I am getting this error on a remote server and not able to replicate it locally?

from a google search it seems to be fixable by adding Convert Infinity DateTime to true

but this does not seem to work?

but then again it seem to be specific to the environment it is running on? can this somehow affect? maybe something like a version where it does not work on or something else?

I cannot seem to understand why it work on one database but not on another?

I should be using the latest postgresql-12 but somehow i can check this?

Exception":"System.InvalidCastException: Can't convert infinite timestamp values to DateTimen   at Npgsql.NpgsqlDataReader.GetValue(Int32 ordinal)n   

Go to Source
Author: kafka