类型: | string |
默认: | GMT |
上下文: | user |
重新开始: | false |
设置用于显示和解释时间戳的时区。内建默认值是GMT
,但是它通常会在postgresql.conf中被覆盖;initdb将安装一个对应于其系统环境的设置。详见datatype-timezones。
建议 [EN]
To avoid a lot of confusion, make sure this is set to your local timeszone. If the server covers multiple time zones, then this should be set on a ROLE or connection basis.
在 StackOverflow
在 pgsql-hackers
- Patch: shouldn't timezone(text, timestamp[tz]) be STABLE?
- RE: Why timestamptz_pl_interval and timestamptz_mi_interval are not immutable?
- Re: Default to TIMESTAMP WITH TIME ZONE?
- Re: mark the timestamptz variant of date_bin() as stable
- Why timestamptz_pl_interval and timestamptz_mi_interval are not immutable?