Method ReadDateTimeOffset(DbDataReader, int)
Reads a date column of a redb table into its portable form.
PostgreSQL and SQL Server store these columns natively. SQLite stores them as a UTC Julian
day (REAL), and the number has to be decoded the way the redb SQLite provider decodes it.
The write side of the same seam is , which stores a
in the form the provider reads.
public DateTimeOffset ReadDateTimeOffset(DbDataReader reader, int ordinal)
Remarks
Decoded here, not by the driver: the driver's own Julian conversion returns a date of
unspecified kind and keeps sub-millisecond noise of the REAL, while the redb SQLite provider
reads the number as UTC rounded to the millisecond. A database filled by an earlier import
holds these columns as TEXT; that form is read too.