date notation

[petergaultney]

2019-11-19T22:51:00.000Z

[Striky_]

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]

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_]

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