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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input
Date: 2003-01-09 14:26:22
Message-ID: 29239.1042122382@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jakub Ouhrabka 2003-01-09 14:37:26 Re: Help - moving data to new table structure
Previous Message Brian Johnson 2003-01-09 14:15:43 Help - moving data to new table structure