Re: Comma Comma Comma 8601

On Jul 23, 2013, at 1:17 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Does that create any ambiguities against formats we already support?
> I'm worried about examples like this one:
>
> select 'monday, july 22, 22:30 2013'::timestamptz;
> timestamptz
> ------------------------
> 2013-07-22 22:30:00-04
> (1 row)
>
> Right now I'm pretty sure that the datetime parser treats comma as a
> noise symbol. If that stops being true, we're likely to break some
> applications out there (admittedly, possibly rather strange ones,
> but still ...)

I kind of suspect not, since this fails:

david=# select '12:24:53 654'::time;
ERROR: invalid input syntax for type time: "12:24:53 654"
LINE 1: select '12:24:53 654'::time;
^

I would have guessed that the time parser gets to a state where it knows it is dealing with a ISO-8601-style time. But I have not looked at the code, of course.

David