I’m having a bizarre problem which appear to be particular to my postgres database on my check server, and never on my native database.
Everytime I insert somerthing to my database I get an error
System.InvalidCastException: Cannot convert infinite timestamp values to DateTime
And I can’t appear to grasp why I get this error on a distant server and never capable of replicate it regionally?
from a google search it appears to be fixable by including
Convert Infinity DateTime to true
however this doesn’t appear to work?
however then once more it appear to be particular to the surroundings it’s operating on? can this someway have an effect on? perhaps one thing like a model the place it doesn’t work on or one thing else?
I can’t appear to grasp why it work on one database however not on one other?
I ought to be utilizing the newest postgresql-12 however someway i can verify this?
Exception":"System.InvalidCastException: Cannot convert infinite timestamp values to DateTimen at Npgsql.NpgsqlDataReader.GetValue(Int32 ordinal)n