I am logging machine data and would like to have a time stamp with local time from the machine. The (generated) column is created as
ts_crate TIMESTAMP WITHOUT TIME ZONE GENERATED ALWAYS AS CURRENT_TIMESTAMP
and when I query the last entries with
SELECT * from mibrecords WHERE ts_crate >= CURRENT_TIMESTAMP - INTERVAL '1' MINUTE;
I get the proper results although the timestamp is in UTC not GMT+1.
What is the best practice to get the right timestamps? Re-converting with every query seems clunky and offsets are sure to be difficult with summer / winter time.
Thanks a lot for your insights,
edit: If possible, I would like to avoid time zones for simplicity… but Iif thats the way forward, then so be it.