Some notes regarding timestamps.
Defining a Timestamp
A timestamp is stored as a 26 character field. But, the system looks at it as a special data type and enforces the rules it has set up for timestamps.
The format for a timestamp is is YYYY-MM-DD-HH.MM.SS.XXXXXX (Year-Month-Day-Hour.Minute.Second.Milliseconds).
An example would be ’2011-09-14-22.06.48.592000′ (Year: 2011 / Month: 09 / Day: 14 / Hour: 22 / Minute: 06 / Second: 48 / Millisecond: 592000) .
The default value for a “*blank” time stamp is ’0001-01-01-00.00.00.000000′.
In DDS a timestamp is defined with just the field name and a ‘Z’ in the data type column.Read More...