On Jul 23, 2013, at 6:24 PM, David E. Wheeler wrote:
> 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 p
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
> (
"David E. Wheeler" 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 abou
Hackers,
According to [Wikipedia](https://en.wikipedia.org/wiki/ISO_8601#Times):
> Decimal fractions may also be added to any of the three time elements. A
> decimal mark, either a comma or a dot (without any preference as stated in
> resolution 10 of the 22nd General Conference CGPM in 2003,[1
