The values returned by SYS TYPES for the time data types needs adjusting for the following attributes: MINIMUM_SCALE, MAXIMUM_SCALE and SQL_DATETIME_SUB as follows:
- the
DATE and TIME must have the values swapped for MINIMUM_SCALE and MAXIMUM_SCALE attributes (since DATE has no seconds component);
SQL_DATETIME_SUB must have these subcode values:
- for
DATE: 1;
- for
TIME: 2.
Current values (for convenience):
TYPE_NAME | DATA_TYPE | PRECISION |LITERAL_PREFIX |LITERAL_SUFFIX | CREATE_PARAMS | NULLABLE |CASE_SENSITIVE | SEARCHABLE |UNSIGNED_ATTRIBUTE|FIXED_PREC_SCALE|AUTO_INCREMENT |LOCAL_TYPE_NAME| MINIMUM_SCALE | MAXIMUM_SCALE | SQL_DATA_TYPE |SQL_DATETIME_SUB|NUM_PREC_RADIX |INTERVAL_PRECISION
-------------------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+------------------+----------------+---------------+---------------+---------------+---------------+---------------+----------------+---------------+------------------
DATE |91 |29 |' |' |null |2 |false |3 |true |false |false |null |3 |3 |91 |0 |null |null
TIME |92 |18 |' |' |null |2 |false |3 |true |false |false |null |null |null |92 |0 |null |null
DATETIME |93 |29 |' |' |null |2 |false |3 |true |false |false |null |3 |3 |9 |3 |null |null
The values returned by
SYS TYPESfor the time data types needs adjusting for the following attributes:MINIMUM_SCALE,MAXIMUM_SCALEandSQL_DATETIME_SUBas follows:DATEandTIMEmust have the values swapped forMINIMUM_SCALEandMAXIMUM_SCALEattributes (sinceDATEhas no seconds component);SQL_DATETIME_SUBmust have these subcode values:DATE:1;TIME:2.Current values (for convenience):