Jeremy Morton <ad...@game-point.net> writes: > Oh well. Guess I keep using SQL Server then. datetimeoffset makes it > impossible for developers to make the mistake of forgetting to use UTC > instead of local datetime,
Really? That would be a remarkable feat for a mere datatype to accomplish. > and for that reason alone it makes it > invaluable in my opinion. It should be used universally instead of > datetime. What's it do that timestamptz together with setting timezone to UTC doesn't? regards, tom lane