future-printer-83389
11/26/2024, 2:36 AMfrom_unixtime(completetime / 1000.0) AT TIME ZONE 'Asia/Shanghai' AS timestamp
All datetime use current UTC time as fallback, which is wrong.
I have to use timezone 'UTC' to avoid this error.future-printer-83389
11/28/2024, 8:31 AM