Reputation
907
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 12
Newest
 Scholar
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 38 votes cast
May
27
awarded  Scholar
May
27
accepted How do you store “fuzzy dates” into a database?
Jan
24
awarded  Great Question
Aug
17
awarded  Yearling
May
1
awarded  Nice Answer
Mar
31
awarded  Nice Question
Aug
28
awarded  Favorite Question
Aug
17
awarded  Yearling
Apr
11
awarded  Notable Question
Apr
9
comment In plain English, what is a database index most similar to?
And also, every time you write a new entry into the dictionary, the index has to be updated.
Apr
8
awarded  Popular Question
Apr
8
awarded  Mortarboard
Apr
8
awarded  Good Question
Apr
8
answered How do you store “fuzzy dates” into a database?
Apr
8
awarded  Commentator
Apr
8
comment How do you store “fuzzy dates” into a database?
HMM, what about maybe perhaps embedding the accuracy into the microseconds of the timestamp? If the microseconds == .11111111 then the accuracy is month. If the microseconds == .22222222, then the accuracy is by day, etc...
Apr
8
comment How do you store “fuzzy dates” into a database?
@aslum: Most database systems will reject that as an invalid date value
Apr
8
awarded  Nice Question
Apr
8
revised How do you store “fuzzy dates” into a database?
added 380 characters in body
Apr
8
comment How do you store “fuzzy dates” into a database?
@MichaelT: yes, it is important to differentiate.