Epoch Mania
Recently I see an increase in questions in various forums (including Stackoverflow) where people are using (big) integer values instead of proper timestamp
values to represent timestamps values (less so for DATE values though).
All modern databases systems provide highly efficient data types to store real timestamp
values, but I often get questions asking what the actual downside of using a “UNIX epoch” instead of a proper timestamp
is.