Open aakarshg opened 4 months ago
Here's the sample data from the postgres table:
database=> select created_time, last_modified_time from blah where <select_row>; created_time | last_modified_time -------------------------+---------------------------- 2023-01-28 12:55:05.094 | 2023-08-06 00:36:48.435488 (1 row) database=> select EXTRACT(EPOCH from created_time) as created_time, EXTRACT(EPOCH from last_modified_time) as last_modified_time from blah where <select_row>; created_time | last_modified_time ----------------+-------------------- 1674910505.094 | 1691282208.435488 (1 row)
The same row however shows up in BQ as follows:
created_time | last_modified_time | -- | -- | -- 1 | 2023-01-28 12:55:05.940000 UTC | 2023-08-06 00:36:48.435488 UTC
As we can see the created_time has the decimal right shifted by 1 digit, but last_modified_time remains unchanged.
Additional details:
BQ connector version 2.5.2
Here's the sample data from the postgres table:
The same row however shows up in BQ as follows:
As we can see the created_time has the decimal right shifted by 1 digit, but last_modified_time remains unchanged.
Additional details:
BQ connector version 2.5.2