Standard Timestamp Format: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

5 December 2023

  • curprev 18:4418:44, 5 December 2023Rob talk contribs 503 bytes +503 Created page with "Timestamps used in database import scripts and files are always rendered in [https://en.wikipedia.org/wiki/ISO_8601 ISO 8601] format. This creates timestamps in the form, <code>2010-10-21T17:01:22Z</code> for a date with time and <code>2010-10-21</code> for just a date. There are several benefits to this format: * MS Excel won't mangle it; * It sorts correctly; * The fields are unambiguous; * It is easy to parse with Python or R. All timestamps are converted into UTC f..."