Timeline for Is it against normal form to include columns with date parts if there is a datetime column in the same table?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 22, 2016 at 21:36 | comment | added | Walter Mitty | I my teammate and I devised the approach independently, and I'm sure thousands of other database people haave as welll. It's good to know that it has acquired a common name. Thanks. | |
| Nov 22, 2016 at 19:48 | comment | added | Zachary Weber | The table I am talking about wouldn't hold financial data, but is more of a "log" or "register" of data. Each row doesn't mean anything without some additional context. One row could represent a batch done in a month, the next for a whole year, the next for a quarter etc... I think I understand what you are talking about, but I don't think your suggestion would work for me specifically. Maybe I didn't provide enough detail in my original question. | |
| Nov 22, 2016 at 9:29 | comment | added | Andriy M | I think your alternative approach is more generally called calendar table. | |
| Nov 22, 2016 at 1:16 | history | answered | Walter Mitty | CC BY-SA 3.0 |