Timestamps & ISO8601

ISO8601

ISO8601 is an international standard for formatting dates & times, often used by databases.

Use "as iso8601" to convert into this format:

April 1, 2019 3:30pm as iso8601               | 2019-04-01T15:30:00+11:00

Use "to date" to convert into a regular date format:

2019-04-01T15:30:00 to date                   | 1 April 2019 at 3:30 pm

Timestamps

Unix time is a system for describing a moment in time, often used in programming. A timestamp is the number of seconds that have passed since the "reference date" (January 1st, 1970).

April 1, 2019 to timestamp               | 1554109200
1559740303.48 to date                    | 5 June 2019 at 11:11 pm

To get a timestamp for the present moment, use current timestamp

current timestamp                         | 1559740303.48

Millisecond timestamps

You can convert millisecond timestamps into dates as well

1733823083000 to date                         | 10 December 2024 at 8:31:23 pm

Last updated

Was this helpful?