3 ms·
I'm a technical person. I also hate time zones, month names and weekdays. Those are utterly meaningless. YYYYMMDDHHMMSS (UTC only) is the format I'm using with
by Sami_Lehtinen 12y ago
I'm a technical person. I also hate time zones, month names and weekdays. Those are utterly meaningless.
YYYYMMDDHHMMSS (UTC only) is the format I'm using with all projects. It's just compacted form of 2015-01-17T07:18:16Z aka ISO_8601. When working with globally distributed teams and comparing event logs etc. One single time indicator is the way to go. Alternate format is classical UNIX time which is nice and can be stored as INT if second resolution is enough. 1421479099 but isn't so well human readable. Yet it's trivial to convert of course.