Re: Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input

Frank van Vugt <ftm.van.vugt@foxi.nl> writes:
> Please allow input of the form
>     "1997-12-17T07:37:16-08"

Seems to be there already since 7.2.

regression=# select '2003-01-09 09:23:51.308301-05'::timestamptz;
          timestamptz
-------------------------------
 2003-01-09 09:23:51.308301-05
(1 row)

regression=# select '2003-01-09T09:23:51.308301-05'::timestamptz;
          timestamptz
-------------------------------
 2003-01-09 09:23:51.308301-05
(1 row)

regression=# select version();
                            version
---------------------------------------------------------------
 PostgreSQL 7.2.3 on hppa-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)


            regards, tom lane