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