Date and timestamp properties

Some Data Catalog object meta data properties are defined as type:integer or type:string with the format: date, format:date-time, or an x-datetimeformat format supported in Compass. These meta data properties are stored in Compass in ISO 8601 RFC3339 format.

Date formats are yyyy-MM-dd, and timestamps are stored as yyyy-MM-ddThh:mm:ss.SSSZ. All timestamps are in UTC. Dates and timestamps have these attributes in Compass:

• INFORMATION_SCHEMA.COLUMNS DATA_TYPE is DATE for dates and TIMESTAMP WITH TIMEZONE for timestamps.
• Timestamps include DATETIME_PRECISION.
• Dates have a size and length of 10. Timestamps have a size and length of 24.
• JDBC getColumns method includes the NUM_PREC_RADIX and COLUMN_SIZE.