Note: OpenESQL and DB2 ECM only
Syntax
SQL [TYPE] [IS] TIMESTAMP
Use TIMESTAMP to generate a single working-storage record to contain all timestamp information.
- 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.
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
|
Example
01 hv-name SQL TYPE IS TIMESTAMP.
generates
01 hv-name PIC X(29).
