Thread: [BUGS] BUG #14568: timezone WIT is not support
The following bug has been logged on the website: Bug reference: 14568 Logged by: xiang liu Email address: xdl@logossmartcard.com PostgreSQL version: 9.5.2 Operating system: rhel 6.8 Description: time WIT is not support by timestamp, eg sat=# select 'Fri Feb 24 18:59:57.342802 2017 WIT'::timestamp; ERROR: invalid input syntax for type timestamp: "Fri Feb 24 18:59:57.342802 2017 WIT" LINE 1: select 'Fri Feb 24 18:59:57.342802 2017 WIT'::timestamp; WIT is defined in pg_timezone_names but not in pg_timezone_abbrevs. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
xdl@logossmartcard.com writes: > time WIT is not support by timestamp, eg It's not in the default set of abbreviations, but you could add it to the set used by your installation easily enough. See https://www.postgresql.org/docs/9.5/static/datetime-config-files.html regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs