Skip site navigation (1) Skip section navigation (2)

Comma Comma Comma 8601

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Comma Comma Comma 8601
Date: 2013-07-22 21:39:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

According to [Wikipedia](

> 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] but with a preference for a comma according to ISO 8601:2004)[12] is used as a separator between the time element and its fraction. A fraction may only be added to the lowest order time element in the representation. To denote "14 hours, 30 and one half minutes", do not include a seconds figure. Represent it as "14:30,5", "1430,5", "14:30.5", or "1430.5". There is no limit on the number of decimal places for the decimal fraction. However, the number of decimal places needs to be agreed to by the communicating parties.

I assume that the Postgres project has no interest in supporting the input of whack times like “14:30.5”, “1430.5”, “14:30.5”, or “1430.5”, right? I mean, that’s just bizarre, amirite?

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?



PS: Apologies if you somehow ended up with a bad 80s pop song in your head.


pgsql-hackers by date

Next:From: Dimitri FontaineDate: 2013-07-22 21:44:59
Subject: Re: proposal - psql - show longest tables
Previous:From: Andres FreundDate: 2013-07-22 21:14:40
Subject: Re: Expression indexes and dependecies

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group