Come up with a proper fix for storing and displaying release dates
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Resonate |
Fix Committed
|
Low
|
Chris Wagner |
Bug Description
The problem is, not all releases have an explicit year, month, *and* day for their "release date". That is, many releases/albums just have a year (e.g., 1999), but not a month and day (e.g., 1999-06-07); others have only a known year and month.
Currently, for an album which has no known month and day (or, at least not known in the sense that it's not in the track's tag), the release date is stored as, for instance, the date "2007-01-01" when it should instead be just "2007".
The trickiest part about this may be coming up with a solution that will allow us to sort by the release date, when doing queries to the database... Will a simple string field work? Maybe a string field in combination with a date field?
Changed in resonate: | |
status: | New → Confirmed |
importance: | Undecided → Low |
We are simply storing the release dates as a string, at this point, which seems to work good enough.