Re: Comma Comma Comma 8601

On Jul 23, 2013, at 1:17 AM, Tom Lane  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