TIMESTAMP-RECORD SQL Type

Use TIMESTAMP-RECORD to generate a group-level record for the timestamp containing individual records for each element of the timestamp as follows:

• Year
• Month
• Day
• Hour
• Minute
• Second
• Fractional second

To insert data, you must pass valid data in the generated field names.

• Data must be organized in fixed date/time formats.
• Fractional seconds are supported up to nine digits. However, this value can vary depending on your target DBMS and your ODBC driver. For example, DB2 ECM limits fractional seconds to six digits. Microsoft SQL Server limits fractional seconds to three digits. See your DBMS or ODBC driver documentation for more information.
• Fractional data is passed left justified, and must contain the number of digits defined in your record. For example, to pass a fractional value of 678 to a record that defines fractional data as nine digits, move the value 678000000.
• Fractional data is right justified when returned from a SELECT or FETCH statement.
• Because of the way SQL Server stores date/time values, it might round the last fractional digit of a fractional value up or down depending on the digit. For example:

  If you pass...	SQL Server returns...
  01/01/98 23:59.59.999	1998-01-02 00:00:00.000
  01/01/98 23:59.59.995	1998-01-01 23:59:59.997
  01/01/98 23:59.59.996	1998-01-01 23:59:59.997
  01/01/98 23:59.59.997	1998-01-01 23:59:59.997
  01/01/98 23:59.59.998	1998-01-01 23:59:59.997
  01/01/98 23:59.59.992	1998-01-01 23:59:59.993
  01/01/98 23:59.59.993	1998-01-01 23:59:59.993
  01/01/98 23:59.59.994	1998-01-01 23:59:59.993
  01/01/98 23:59.59.990	1998-01-01 23:59:59.990
  01/01/98 23:59.59.991	1998-01-01 23:59:59.990