Edit codes for timestamp data
The timestamp is a seven-part value designating date and time,
including microseconds. There is only one edit code (TSI) for the
timestamp data type. The TSI edit code can only be used with columns
that have a timestamp data type.
- TSI
- yyyy-mm-dd-hh.mm.ss.nnnnnn
- yyyy
- Four-digit value representing the year
- mm
- Two-digit value representing the month
- dd
- Two-digit value representing the day
- hh
- Two-digit value representing the hour
- mm
- Two-digit value representing the minutes
- ss
- Two-digit value representing the seconds
- nnnnnn
- Six-digit value representing the number of microseconds
- The timestamp value:
- 1991-12-29-23.25.15.123000
- Formatted with the TSI edit code:
- 1991-12-29-23.25.15.123000
