Choose a time-scale
Choose a data-type
A 'date' is not a time-stamp, is not a number of milliseconds
- Using points on one timescale to model ranges on another
- Thinking that "UTC" will solve your modelling problems
Your language/database's date/time data-types ...
...are broken; don't use them.
... is not a time-scale.