| From: | Erik Wienhold <ewie(at)ewie(dot)name> |
|---|---|
| To: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Roman Frołow <rofrol(at)gmail(dot)com>, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: T is a mandatory date time separator in RFC3339 but documentation states differently |
| Date: | 2023-11-15 08:37:57 |
| Message-ID: | n5j5tsqbh55orr36bhpibcd7k3ckztsu75q4uhmmncbpedu4ok@vib6inzin3el |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On 2023-11-15 08:16 +0100, Peter Eisentraut wrote:
> The SQL standard does not refer to ISO 8601 to define date formats, it has
> its own definitions. In fact, PostgreSQL implements more date formats than
> the SQL standard requires.
Really? Then what does the standard mean with section "Definitions
taken from ISO 8601" which I quoted in [1]? Just using the term "date"
without adopting its syntax?
And the Postgres docs also say "The SQL standard requires the use of the
ISO 8601 format." [2]
[1] https://www.postgresql.org/message-id/piavtdd7mhmkpzpgvxaek3hz3e2kan3c2fitn5iqta6nyrpgyl%40txongxshxkxw
[2] https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT
--
Erik
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2023-11-15 11:53:33 | Re: T is a mandatory date time separator in RFC3339 but documentation states differently |
| Previous Message | Peter Eisentraut | 2023-11-15 07:16:04 | Re: T is a mandatory date time separator in RFC3339 but documentation states differently |