3 ms·
I agree (though less indignantly). TIMESTAMP WITH TIME ZONE basically makes me confused as it is trying to run around guessing how to actively solve a problem
by zzzeek 3y ago
I agree (though less indignantly). TIMESTAMP WITH TIME ZONE basically makes me confused as it is trying to run around guessing how to actively solve a problem I dont actually have, which is, "I don't know how to correctly represent datetimes in my application".
- deleted 3y ago[deleted]
- Figs 3y agoI may have been a bit over the top there. :p TIMESTAMP WITH TIME ZONE just sets off my lingering issues from an old project. All the other posts in this thread misunderstanding it really demonstrate the point about it being a source of recurring confusion though!
- zzzeek 3y agowhat people usually want, when they are confused about that datatype, is a datatype that stores the timestamp *and* a specific timezone to go along with it, so you get back a timestamp with that same timezone if you did not ask to convert it to another. that would be a bit less efficient from a storage perspective but would likely be more intuitive.