DB2 graphic  QMF Version 8

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


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004