What does the ‘Z’ mean in Unix timestamp ‘120314170138Z’?

by

Yes. ‘Z’ stands for Zulu time, which is also GMT and UTC.

From http://en.wikipedia.org/wiki/Coordinated_Universal_Time:

The UTC time zone is sometimes denoted by the letter Z—a reference to
the equivalent nautical time zone (GMT), which has been denoted by a Z
since about 1950. The letter also refers to the “zone description” of
zero hours, which has been used since 1920 (see time zone history).
Since the NATO phonetic alphabet and amateur radio word for Z is
“Zulu”, UTC is sometimes known as Zulu time.

Technically, because the definition of nautical time zones is based on longitudinal position, the Z time is not exactly identical to the actual GMT time ‘zone’. However, since it is primarily used as a reference time, it doesn’t matter what area of Earth it applies to as long as everyone uses the same reference.

From wikipedia again, http://en.wikipedia.org/wiki/Nautical_time:

Around 1950, a letter suffix was added to the zone description,
assigning Z to the zero zone, and A–M (except J) to the east and N–Y
to the west (J may be assigned to local time in non-nautical
applications; zones M and Y have the same clock time but differ by 24
hours: a full day). These were to be vocalized using a phonetic
alphabet which pronounces the letter Z as Zulu, leading sometimes to
the use of the term “Zulu Time”. The Greenwich time zone runs from
7.5°W to 7.5°E longitude, while zone A runs from 7.5°E to 22.5°E longitude, etc.

More Related Contents:

  1. Do UNIX timestamps change across timezones?
  2. Date time conversion from timezone to timezone in sql server
  3. Timezone conversion in php
  4. Convert Date/Time for given Timezone – java
  5. How to get the unix timestamp in C#
  6. MySQL convert date string to Unix timestamp
  7. How should I populate a list of IANA / Olson time zones from Noda Time?
  8. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  9. Get current time with a phone number
  10. How to get time zone name from an offset?
  11. git: timezone and timestamp format
  12. How to convert a 13 digit Unix Timestamp to Date and time?
  13. Difference between timestamps with/without time zone in PostgreSQL
  14. Mapping US zip code to time zone [closed]
  15. A day without midnight
  16. Use MySQL to determine whether today is a user’s birthday
  17. Time series plot gets offset by 2 hours if scale_x_datetime is used
  18. Storing time information: Timezone required?
  19. How to get Unix timestamp in php based on timezone
  20. Parse DateTime with time zone of form PST/CEST/UTC/etc
  21. Dates with no time or timezone component in Java/MySQL
  22. How can I set the default timezone in node.js?
  23. How to extract CN from X509Certificate in Java?
  24. How to convert date time from one time zone to another time zone
  25. Get the Olson TZ name for the local timezone?
  26. Java 8 timezone conversions
  27. How to update timezonedb in PHP (updating timezones info)?
  28. How can I handle time zones in my webapp?
  29. Get TimeZone offset value from TimeZone without TimeZone name
  30. Get utc offset from timezone in Javascript

Leave a Comment