Date and Time

Choose a time-scale

Common ones:

Choose a data-type

A 'date' is not a time-stamp, is not a number of milliseconds

Stop!

Your language/database's date/time data-types ...

...are broken; don't use them.

UTC ...

... is not a time-scale.