On 11/27/19 2:19 PM, Ron wrote:
> Hi,
>
> In 9.6, does it default to UTC, the postgresql.conf timezone value
> (US/Eastern) value or to local system time?
>
>
test_(postgres)# show timezone;
TimeZone
------------
US/Pacific
test_(postgres)# create role ts_test valid until '12/31/2020';
CREATE ROLE
ts_test | Cannot login
+| {}
| Password valid until 2020-12-31 00:00:00-08
|
Best guess it operates like if specifying a value for a timestamptz field.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com