Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What 'T' and 'Z' means in date

Tags:

time

I need some information about this date '2015-05-12T00:00:00Z'. What does it mean 'T' and 'Z'? Anyone can help me?I don't know how they mean. I need to convert this data in another format

like image 934
Fuffy Avatar asked May 13 '15 08:05

Fuffy


People also ask

What does T after date mean?

The ISO 8601 standard defines formats for representing date-time values as text. The T is just a marker for where the time part begins. The Z is an abbreviation of +00:00 , meaning UTC (an offset of zero hour-minutes-seconds). Pronounced “Zulu” per military and aviation tradition.

What does the Z mean in date format?

Z is the zone designator for the zero UTC offset. "09:30 UTC" is therefore represented as "09:30Z" or "T0930Z". "14:45:15 UTC" would be "14:45:15Z" or "T144515Z". The Z suffix in the ISO 8601 time representation is sometimes referred to as "Zulu time" because the same letter is used to designate the Zulu time zone.

What is TZ in it date time?

For DATETIME-TZ, the value represents an absolute date and time, and there is no data loss when passing parameters between sessions in different time zones.


1 Answers

ISO 8601

The ISO 8601 standard defines formats for representing date-time values as text.

  • The T is just a marker for where the time part begins.
  • The Z is an abbreviation of +00:00, meaning UTC (an offset of zero hour-minutes-seconds). Pronounced “Zulu” per military and aviation tradition.

From the Wikipedia article on ISO 8601

A single point in time can be represented by concatenating a complete date expression, the letter T as a delimiter, and a valid time expression. For example "2007-04-05T14:30".

[...]

If the time is in UTC, add a Z directly after the time without a space. Z is the zone designator for the zero UTC offset. "09:30 UTC" is therefore represented as "09:30Z" or "0930Z". "14:45:15 UTC" would be "14:45:15Z" or "144515Z".

like image 181
aioobe Avatar answered Oct 05 '22 00:10

aioobe