[mb-users] [unknown date]

Steve Wyles steve at inhouse.co.uk
Fri Jan 11 18:01:20 UTC 2008


On Fri, 11 Jan 2008, Oliver Charles wrote:

>
>> If we're going to use a fake year as a bogus year, then lets pick
>> something that actually IS bogus, rather than picking something that's
>> just not frequently actually valid.  Say, 9999?
>
> This seems to make more sense, I would hope that we've actually fixed
> the problem by then ;) I'm not sure if the db can actually hold years
> that high however. 2020 should be enough.

The release dates are actually stored as text of the format YYYY-MM-DD, so 
db limitations don't have any impact here.

I'd recommend using something which will never occur as the unknown date 
value, 0000-00-00 is the obvious one.

Steve (inhouseuk)



More information about the MusicBrainz-users mailing list