←back to thread

Timestamps and Time Zones in PostgreSQL (2016)

(phili.pe)
189 points GordonS | 1 comments | 30 Mar 19 21:47 UTC | HN request time: 0s | source
Show context
zeroimpl ◴[31 Mar 19 01:28 UTC] No.19533112[source]▶
I sometimes wish there was an actual "TIMESTAMP WITH TIME ZONE" type that stored the input timestamp as well. Basically, a version that didn't canonicalize the input by converting to UTC. This way, I can easily show timestamps to the user in the time zone they used to input them.
replies(6): >>19533287 #>>19534038 #>>19534057 #>>19534316 #>>19535066 #>>19541872 #
1. mastazi ◴[31 Mar 19 07:12 UTC] No.19534316[source]▶
When you say "timestamp", many programmers think about UNIX timestamps which, by definition, cannot have a timezone, so to those people a "timestamp with TZ" is a bit of an oxymoron. But I understand where you're coming from.