"David E. Wheeler" <[email protected]> writes:
> But I do wonder if the comma should be allowed for fractional seconds,
> since the spec says it is preferred (and often used in Javaland, I'm
> told). As in "14:30:50,232". Thoughts?
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 ...)
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers