ClickHouseClient icon indicating copy to clipboard operation
ClickHouseClient copied to clipboard

`DateTime64` values less than 1970-01-01 cannot be read

Open MaceWindu opened this issue 3 years ago • 0 comments

From error it looks like values read as UInt64 instead of Int64

System.OverflowException
  Message=The value 0xFFCD8C88F2850000 is greater than the maximal value of the type "System.DateTime". It is only possible to read this value as "System.UInt64".
  StackTrace:
   at Octonica.ClickHouseClient.Types.DateTime64TableColumn.GetValue(Int32 index)
   at Octonica.ClickHouseClient.Types.ReinterpretedTableColumn`2.GetValue(Int32 index)
   at Octonica.ClickHouseClient.ClickHouseDataReader.GetFieldValue[T](Int32 ordinal)

Originally posted by @MaceWindu in https://github.com/Octonica/ClickHouseClient/issues/60#issuecomment-1172932038

MaceWindu avatar Jul 02 '22 17:07 MaceWindu