Unfortunately, some PG Wire clients will convert the timestamp to local time. You can cast the timestamp to long, giving you epoch micros, and then convert them back client-side.
There is a related issue I can dig up in a little while.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| I want to display a timestamp in my timezone, not UTC | 1 | 123 | August 13, 2024 | |
| How to import nanosecond timestamps into QuestDB via http csv import? | 1 | 151 | June 26, 2024 | |
| How to import time series data with the following timestamp format (2016-04-26 21:00:00+00) | 1 | 172 | June 26, 2024 | |
| SQL format for converting to microseconds? | 3 | 81 | September 2, 2024 | |
| Importing CSV with timestamps in milliseconds | 3 | 52 | March 28, 2025 |