How to handle Dates in a database

an authorative statement

It's simple, always use UTC. To quote an internationally known developer with years of experience:

use utc everywhere but the ui layer, its the right fucking thing to do

— @Yantr.io

Another wellknown figure in the development scene goes even further

might as well use utc on the ui layer and tell your clients to learn

— @Buildstarted

other sources can be quoted as

don't be stupid and just freaking store the times in UTC dummy

— @ben.hyrman

to further support the main point:

ALWAYS USE UTC

and if that's not authorative enough, better call saul