View Revisions: Issue #6143

Summary 0006143: Postgres timestamp with time zone columns get their values formatted incorrectly when extracted for a load
Revision 2023-12-04 18:48 by emiller
Description When extracting data for a load that includes a Postgres timestamp with time zone column, the values get formatted incorrectly. Here is an example:

Expected value: 2023-12-04 12:34:56.123456 -05:00
Actual value: 2023-12-04 12:34:56.123456-05

This leads to the time portion of the timestamp being incorrect in the target table.
Revision 2023-12-04 18:44 by emiller
Description When extracting data for a load that includes a Postgres timestamp with time zone column, the values get formatted incorrectly. Here is an example:

Expected value: 2023-12-04 12:34:56.123456 -05:00
Actual value: 2023-12-04 12:34:56.123456-05