TIMESTAMP WITHOUT TIME ZONE
时间: 2024-02-10 16:58:17 浏览: 66
PostgreSQL更新表时时间戳不会自动更新的解决方法
5星 · 资源好评率100%
A TIMESTAMP WITHOUT TIME ZONE is a data type in a database that stores a specific point in time, down to the second, without any reference to a particular time zone. This means that the timestamp is universal and does not change based on the location or time zone of the user or the server.
For example, if a user enters a timestamp of "2021-09-22 14:30:00" into a database with a TIMESTAMP WITHOUT TIME ZONE data type, it will be stored as it is. If another user in a different time zone accesses the same timestamp, it will still be displayed as "2021-09-22 14:30:00" without any conversion to their local time zone.
It is important to note that a TIMESTAMP WITHOUT TIME ZONE should not be confused with a TIMESTAMP WITH TIME ZONE, which includes an offset to indicate the time zone.
阅读全文