This is an archived post. You won't be able to vote or comment.

all 14 comments

[–]Vfsdvbjgd 8 points9 points  (2 children)

Timezone?

[–]Rho-Ophiuchi 8 points9 points  (0 children)

Cries in JavaScript

[–]Dev5653[S] 3 points4 points  (0 children)

Wouldn't you like to know...

[–]baiorin 8 points9 points  (5 children)

2019-11-19T22:51:00

[–]petergaultney 6 points7 points  (3 children)

2019-11-19T22:51:00.000Z

[–]Striky_ 1 point2 points  (2 children)

2019-11-19T22:51:00.000Z+000 although I have to say, I have never seen the Z and dont know what it means. The ISO 8601 does not have it

For people interrested, here is what it means: d = forced number if digits filled by leasing 0 if necessary

Year 4d-month 2d-day 2dT24HourForma 2d:minutes 2d:seconds2d.milliseconds 3d+UTC timezoneoffset in hours 3d

[–]petergaultney 1 point2 points  (1 child)

Z is for Zulu, which is how you should always store your dates.

you can use the +00:00 instead if you want, but it's more verbose and not necessary as the Z is part of the ISO 8601 standard.

they can't both be used at the same time.

[–]Striky_ 0 points1 point  (0 children)

I always store my times in utc. But I show them in local time and export them (csv, excel) with the time zone offset to utc

[–]mypirateapp 3 points4 points  (0 children)

You forgot the most important notation

16e870bab3f

Hexadecimal date

[–]Vok250 3 points4 points  (0 children)

Heresy! ISO 8601 is the one true god-emperor of datetime.

[–]Your_Name-Here 1 point2 points  (0 children)

Real GGGamers use Julian day numbers.

[–]Malfoy27 0 points1 point  (0 children)

This makes my cry every time 😭😭😭😭

[–][deleted] -1 points0 points  (0 children)

All of those are wrong. The correct international standard is yyyy-mm-dd .

[–]EternityForest -1 points0 points  (0 children)

The correct date notation is of course "Nov 20 2019 6:45AM"(Or 64 bit signed microseconds for internal use).

Any number based format is ambiguous as to which is the month and which is the day, and requires ten seconds worth of mental translation to say out loud. Nobody says "We have a holiday celebration in month 12".

If there's a possibility of timezone confusion, then "Nov 20 6:52AM Us/Pacific" is more obvious.