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
[ Previous Page | Next Page | Contents | Index ]