Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
Date
Msg-id 29239.1042122382@sss.pgh.pa.us
Whole thread Raw
In response to Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Responses Re: Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Brian Johnson"
Date:
Subject: Help - moving data to new table structure
Next
From: Jakub Ouhrabka
Date:
Subject: Re: Help - moving data to new table structure