On Jul 23, 2013, at 6:24 PM, David E. Wheeler da...@justatheory.com 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
On Jul 23, 2013, at 1:17 AM, Tom Lane t...@sss.pgh.pa.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
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,[11]
David E. Wheeler da...@justatheory.com 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?