There are a few variations of the above format that you should be aware of. Sometimes, you will find a
Z after the time, e.g.
'1967-07-18 20:49:55Z'. The
Z is the time zone indicator for the Coordinated Universal Time UTC. To indicate another time zone, add the offset from UTC directly after the time. The format to use for the offset is
'-hh:mm', conversely. For example, the time in Berlin, Germany, during the winter would have an additional
'+01:00' at the end. Sometimes,
'+0100' is used instead. Example:
T between the date part and the time part of the timestamp is just an alternative character to separate time and date, sometimes replacing the space character.