- My goal: store time in UTC, display time in local TZ
- Issue: the datetime.value.unixTimestamp is in local TZ regardless of "Value" setting set to Local or UTC
- Additional info:
wait
1 Like
no, wait.
I have a data source which has 1752334885 as a timestamp.
It corresponds to:
% date -z UTC -r 1752334885
Sat Jul 12 15:41:25 UTC 2025
but this setting of a table column gives me time in my timezone, not UTC.
which is precisely my local timezone:
% date -r 1752334885
Sat Jul 12 19:41:25 +04 2025
How does that make sense?
I'm also curious to know how times are read and recorded.
I'm in an interesting situation with daylight savings that is causing data to be dropped in my database by Retool at 1AM.
It's meant to drop any records from the same day, with the expectation that the last records of the day survive after midnight as a snapshot.