threads / discuss / 27308

Approxidate with YYYY.MM

Subject: Approxidate with YYYY.MM

## tl;dr

7 messages between May 9, 2011 and May 22, 2011.

replies: 6people: 5as markdown or json

Brian Gernhardt· May 9, 2011, 19:02 UTC · lore
(This is in response to a discussion on #parrot.)
Rakudo (https://github.com/rakudo/rakudo/) uses tags of the form YYYY.MM for their monthly releases.  When we were attempting to find the cause of a slowdown, somewhat was trying to find what commits occurred after the 2011.01 release with "git log --after=2011.01".  His mistake was pointed out but this led to the confusion of why this was parsed as "May 1 2011" instead of "Jan 1 2011".  Shouldn't date.c:match_multi_number() parse something with only two numbers as a beginning of month instead of allowing it to pass through to the generic parsing?
I'm currently nearing finals in school, so lack the time for an RFC patch at the moment.
~~ Brian
Michael J Gruber· May 10, 2011, 06:35 UTC · re: Brian Gernhardt · lore

Re: Approxidate with YYYY.MM

Brian Gernhardt venit, vidit, dixit 09.05.2011 21:02:
Show 11 quoted lines
> (This is in response to a discussion on #parrot.)
> 
> Rakudo (https://github.com/rakudo/rakudo/) uses tags of the form
> YYYY.MM for their monthly releases.  When we were attempting to find
> the cause of a slowdown, somewhat was trying to find what commits
> occurred after the 2011.01 release with "git log --after=2011.01".
> His mistake was pointed out but this led to the confusion of why this
> was parsed as "May 1 2011" instead of "Jan 1 2011".  Shouldn't
> date.c:match_multi_number() parse something with only two numbers as
> a beginning of month instead of allowing it to pass through to the
> generic parsing?

I just don't think there is a format like that. There is dd.mm.[yy]yy and apparently also yyyy.mm.dd, but without leading zeros in mm for the latter. Our date parser also takes "." for a space so that you don't need to quote a space ("1.day.ago"). I can see the logic behind parsing 2011.01 as January 2011, but it's a stretch from the existing formats:

http://en.wikipedia.org/wiki/Calendar_date#Date_format
> I'm currently nearing finals in school, so lack the time for an RFC
> patch at the moment.
Good luck :)
Michael
Andreas Ericsson· May 10, 2011, 06:54 UTC · re: Michael J Gruber · lore

Re: Approxidate with YYYY.MM

On 05/10/2011 08:35 AM, Michael J Gruber wrote:
Show 19 quoted lines
> Brian Gernhardt venit, vidit, dixit 09.05.2011 21:02:
>> (This is in response to a discussion on #parrot.)
>>
>> Rakudo (https://github.com/rakudo/rakudo/) uses tags of the form
>> YYYY.MM for their monthly releases.  When we were attempting to find
>> the cause of a slowdown, somewhat was trying to find what commits
>> occurred after the 2011.01 release with "git log --after=2011.01".
>> His mistake was pointed out but this led to the confusion of why this
>> was parsed as "May 1 2011" instead of "Jan 1 2011".  Shouldn't
>> date.c:match_multi_number() parse something with only two numbers as
>> a beginning of month instead of allowing it to pass through to the
>> generic parsing?
> 
> I just don't think there is a format like that. There is dd.mm.[yy]yy
> and apparently also yyyy.mm.dd, but without leading zeros in mm for the
> latter. Our date parser also takes "." for a space so that you don't
> need to quote a space ("1.day.ago"). I can see the logic behind parsing
> 2011.01 as January 2011, but it's a stretch from the existing formats:
> 

It would be far more logical to parse "2011-01" as "January 2011" as that's the preferred way to write month-precision dates in most countries that use both the metric system and the gregorian calender.

I've never seen that date-type with dot as a separator, but with the dash it's very, very common.

-- 
Andreas Ericsson                   andreas.ericsson@op5.se
OP5 AB                             www.op5.se
Tel: +46 8-230225                  Fax: +46 8-230231

Considering the successes of the wars on alcohol, poverty, drugs and
terror, I think we should give some serious thought to declaring war
on peace.
Michael J Gruber· May 10, 2011, 07:08 UTC · re: Andreas Ericsson · lore

Re: Approxidate with YYYY.MM

Andreas Ericsson venit, vidit, dixit 10.05.2011 08:54:
Show 28 quoted lines
> On 05/10/2011 08:35 AM, Michael J Gruber wrote:
>> Brian Gernhardt venit, vidit, dixit 09.05.2011 21:02:
>>> (This is in response to a discussion on #parrot.)
>>>
>>> Rakudo (https://github.com/rakudo/rakudo/) uses tags of the form
>>> YYYY.MM for their monthly releases.  When we were attempting to find
>>> the cause of a slowdown, somewhat was trying to find what commits
>>> occurred after the 2011.01 release with "git log --after=2011.01".
>>> His mistake was pointed out but this led to the confusion of why this
>>> was parsed as "May 1 2011" instead of "Jan 1 2011".  Shouldn't
>>> date.c:match_multi_number() parse something with only two numbers as
>>> a beginning of month instead of allowing it to pass through to the
>>> generic parsing?
>>
>> I just don't think there is a format like that. There is dd.mm.[yy]yy
>> and apparently also yyyy.mm.dd, but without leading zeros in mm for the
>> latter. Our date parser also takes "." for a space so that you don't
>> need to quote a space ("1.day.ago"). I can see the logic behind parsing
>> 2011.01 as January 2011, but it's a stretch from the existing formats:
>>
> 
> It would be far more logical to parse "2011-01" as "January 2011" as
> that's the preferred way to write month-precision dates in most
> countries that use both the metric system and the gregorian calender.
> 
> I've never seen that date-type with dot as a separator, but with the
> dash it's very, very common.
> 

Exactly that's what I wrote. People misuse the dot format probably as frequently as the dash format, in the sense that the use an ordering which is wrong for the respective separator. We currently parse n.m as day n of month m of the current year for certain n only: We parse

31.3. as March 3rd of the current year 32.3. as May 3rd of 2032

(because May is the current month) which does not make that much sense, admittedly. I would have hoped the latter to be April 1st (current year). I agree that defaulting the month to the current month in the dot format makes no sense, but I think (and I guess we disagree here) that it's a matter of garbage in - garbage out. As for turning that garbage into marbles: 32.3. == 1.4. seems more logical to me. Note that for example

2020.9.11 -> 2020-11-09 07:06:16 +0000

which means that we *never* parse the Chinese yyyy.mm.dd correctly, not even the complete form!

Michael
Victor Engmark· May 10, 2011, 07:40 UTC · lore

Re: Approxidate with YYYY.MM

On 05/10/2011 08:54 AM, Andreas Ericsson wrote:
Show 27 quoted lines
> On 05/10/2011 08:35 AM, Michael J Gruber wrote:
>> Brian Gernhardt venit, vidit, dixit 09.05.2011 21:02:
>>> (This is in response to a discussion on #parrot.)
>>>
>>> Rakudo (https://github.com/rakudo/rakudo/) uses tags of the form
>>> YYYY.MM for their monthly releases.  When we were attempting to find
>>> the cause of a slowdown, somewhat was trying to find what commits
>>> occurred after the 2011.01 release with "git log --after=2011.01".
>>> His mistake was pointed out but this led to the confusion of why this
>>> was parsed as "May 1 2011" instead of "Jan 1 2011".  Shouldn't
>>> date.c:match_multi_number() parse something with only two numbers as
>>> a beginning of month instead of allowing it to pass through to the
>>> generic parsing?
>>
>> I just don't think there is a format like that. There is dd.mm.[yy]yy
>> and apparently also yyyy.mm.dd, but without leading zeros in mm for the
>> latter. Our date parser also takes "." for a space so that you don't
>> need to quote a space ("1.day.ago"). I can see the logic behind parsing
>> 2011.01 as January 2011, but it's a stretch from the existing formats:
>>
> 
> It would be far more logical to parse "2011-01" as "January 2011" as
> that's the preferred way to write month-precision dates in most
> countries that use both the metric system and the gregorian calender.
> 
> I've never seen that date-type with dot as a separator, but with the
> dash it's very, very common.

Seconded. ISO dates are getting pretty common, and in the extended format hyphens are the default separator between year, month, and date <https://secure.wikimedia.org/wikipedia/en/wiki/ISO_8601#Calendar_dates>.

A few notes on support:

GNU `date` 8.5 parses some ISO date strings correctly: $ date --date='2001-02-03' +%Y-%m-%d\ %H:%M:%S 2001-02-03 00:00:00 $ date --date='2001-02-03 04:05:06' +%Y-%m-%d\ %H:%M:%S 2001-02-03 04:05:06

Unfortunately, it doesn't handle partial dates: $ date --date='2001-02' +%Y-%m-%d\ %H:%M:%S date: invalid date `2001-02'

But it does handle HH:MM: $ date --date='04:05' +%Y-%m-%d\ %H:%M:%S 2011-05-10 04:05:00

Basic format dates are sometimes parsed correctly: $ date --date='20010203' +%Y-%m-%d\ %H:%M:%S 2001-02-03 00:00:00

But not with seconds: $ date --date='20010203040506' +%Y-%m-%d\ %H:%M:%S 2001020304-05-06 00:00:00

The W3C recommends the use of ISO dates: <http://www.w3.org/QA/Tips/iso-date>, and their standards, like XML, typically support only ISO dates (or a subset thereof).

Cheers, Victor Engmark

Michael J Gruber· May 10, 2011, 08:36 UTC · re: Victor Engmark · lore

Re: Approxidate with YYYY.MM

Victor Engmark venit, vidit, dixit 10.05.2011 09:40:
Show 32 quoted lines
> On 05/10/2011 08:54 AM, Andreas Ericsson wrote:
>> On 05/10/2011 08:35 AM, Michael J Gruber wrote:
>>> Brian Gernhardt venit, vidit, dixit 09.05.2011 21:02:
>>>> (This is in response to a discussion on #parrot.)
>>>>
>>>> Rakudo (https://github.com/rakudo/rakudo/) uses tags of the form
>>>> YYYY.MM for their monthly releases.  When we were attempting to find
>>>> the cause of a slowdown, somewhat was trying to find what commits
>>>> occurred after the 2011.01 release with "git log --after=2011.01".
>>>> His mistake was pointed out but this led to the confusion of why this
>>>> was parsed as "May 1 2011" instead of "Jan 1 2011".  Shouldn't
>>>> date.c:match_multi_number() parse something with only two numbers as
>>>> a beginning of month instead of allowing it to pass through to the
>>>> generic parsing?
>>>
>>> I just don't think there is a format like that. There is dd.mm.[yy]yy
>>> and apparently also yyyy.mm.dd, but without leading zeros in mm for the
>>> latter. Our date parser also takes "." for a space so that you don't
>>> need to quote a space ("1.day.ago"). I can see the logic behind parsing
>>> 2011.01 as January 2011, but it's a stretch from the existing formats:
>>>
>>
>> It would be far more logical to parse "2011-01" as "January 2011" as
>> that's the preferred way to write month-precision dates in most
>> countries that use both the metric system and the gregorian calender.
>>
>> I've never seen that date-type with dot as a separator, but with the
>> dash it's very, very common.
> 
> Seconded. ISO dates are getting pretty common, and in the extended
> format hyphens are the default separator between year, month, and date
> <https://secure.wikimedia.org/wikipedia/en/wiki/ISO_8601#Calendar_dates>.

Please, guys, this is not about ISO dates. It's about abbreviations of yyyy.mm.dd, and that is not ISO at all!

Incidentally, we do not parse 2010-3 as March of 2010 either. Again, this is not ISO date format (but an unofficial abbreviation). We may decide to dwim that to 2010-03-01, and I would even appreciate that.

But yyyy.mm.dd is a format we don't support at all (because it's no standard), so before supporting an abbreviation we would have to decide about supporting that format.

> A few notes on support:
[notes about ISO dates cut]
Michael
Michael Witten· May 22, 2011, 17:10 UTC · re: Michael J Gruber · lore

Re: Approxidate with YYYY.MM

On Tue, May 10, 2011 at 08:36, Michael J Gruber <git@drmicha.warpmail.net> wrote:

> Incidentally, we do not parse 2010-3 as March of 2010 either. Again,
> this is not ISO date format (but an unofficial abbreviation). We may
> decide to dwim that to 2010-03-01, and I would even appreciate that.

Wouldn't it make the most sense to provide another option to allow the user to specify whatever date format he wants (from the conversion specifiers understood by strptime(3))?

It seems really ridiculous to keep growing the date parsing code.

← back to recent threads