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 |