I have seen it time and again that developers used times and dates in sub-optimal ways. It is not that hard if you understand some basic principles related to time zones.
Some software development teams define a set of non-functional requirements for their projects. Often, this will include a minimum code coverage requirement for the automated test suite. While this may seem like an innocent and well-intentioned requirement, it is mostly useless.
Database tests are a type of automated tests that do not get enough love these days. Everybody is talking about unit tests, acceptance tests, integration and regression tests.