Date and datetime property definitions

Some object properties are defined as dates or date-times in the object metadata definitions of the Data Catalog. These object properties include the date or timestamp format of the data values.

Compass converts dates and timestamps to standard ISO 8601 RFC 3339 formats. Dates are converted to yyyy-MM-dd format. Date-times are converted to yyyy-MM-dd'T'HH:mm:ss.SSS'Z' format. All timestamps are considered in UTC time; Compass does not convert timestamps to UTC.

Compass does not recognize properties that are defined as a type of “time”.