 <p>Putting aside the argument of whether dates should be stored in UTC or not, the place to check for these kinds of things in your code is in the build process, or failing that, using a pre-commit hook.</p> <p>The latter will only allow the developer to commit code that adheres to your standards. Doing it at the database layer is too late, IMO.</p>