2 ms·
Great! Then if they are unambiguous they can be inserted directly or disambiguated and then inserted. At query time any format can be used to represent them t
by mulmen 5y ago
Great! Then if they are unambiguous they can be inserted directly or disambiguated and then inserted. At query time any format can be used to represent them to a user.
- jameshart 5y agoAh, so you're suggesting instead of storing 'what a person calls this date' as the key, you instead convert it to some underlying representation that you can then choose to present in different calendars - like a UNIX epoch-relative offset or something. Congratulations, you just created another synthetic key for describing dates.
- deleted 5y ago[deleted]
- mulmen 5y agoThe date is a natural key. The format string is only a representation. Implementation details are irrelevant to the definition of a natural key.
- goto11 5y agoThat is not what synthetic key means. A synthetic key is a key which does not carry any information, like an auto-incremented integer. A date is a natural key, regardless of the underlying representation.