Closed. This question is
opinion-based. It is not currently accepting answers.
Answer
Solution:
That would be a datetime(3) type, except that that won't store the offset.
If the offset is ever non-0, I would store the time in utc and the offset in a separate column, e.g original_offset.
Source