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