3 ms·
Sorry, I clicked on wrong tab, when responding. It was a sane choice, to use local timezone for dates, in the past, but it's no longer a sane choice in today's
by drran 5y ago
Sorry, I clicked on wrong tab, when responding.
It was a sane choice, to use local timezone for dates, in the past, but it's no longer a sane choice in today's world, because a database can be at another continent, while users can be all around the world.
«Timestamp» is somewhat different from «date». Timestamps can be represented by different dates in different time zones or different chronicle. «Local timestamps» with time zone are prone to error when time zone shifts.