Edit codes for timestamp data

You use timestamp data edit codes to format fields containing timestamp information in reports.

The following timestamp edit codes are available:

Edit Code Format Notes
TSI yyyy–mm–dd–hh.mm.ss.nnnnnnnnnnnn Where:
  • yyyy is the four digit year
  • mm is the two digit month
  • dd is the two digit day
  • hh is the two digit hour
  • mm is the two digit minute
  • ss is the two digit second
  • nnnnnnnnnnnn is the twelve digit fractional seconds
TSZ
yyyy–mm–dd–hh.mm.ss.nnnnnnnnnnnn
±th:tm
Where:
  • yyyy is the four digit year
  • mm is the two digit month
  • dd is the two digit day
  • hh is the two digit hour
  • mm is the two digit minute
  • ss is the two digit second
  • nnnnnnnnnnnn is the twelve digit fractional seconds
  • ±th is the two-digit value representing the time zone hour, shown as an offset relative to UTC
  • tm is the two-digit value representing the time zone minutes between 0 and 59
Note: To specify UTC, you can either specify a time zone of -24:00 or +24:00 or replace the time zone offset and its sign with an uppercase Z.