Date/Time is such a tricky thing. I think that's we migrated toward the
simplest solution in the first place.
For days/weeks/months, I think the math cited below works pretty well. That
is, if we're not talking about calendar months. As soon as we need to query
based on calendar things, we tend
This is a related but different question/comment.
In the six or so years of using MySQL, my various teams have never used
anything except an unsigned INT and UNIX Epoch time to record timestamps.
The given is, of course, we have always been a Perl/C/C++/UNIX shop, and we
will be for a long time, a
