Zoomdata Version

Supported Date and Time Formats

Zoomdata supports any valid date and time formats, including the ISO (International Organization for Standardization) 8601 standard. ISO 8601 (http://en.wikipedia.org/wiki/ISO_8601) provides a method for representing dates and times that help avoid misinterpretation of numeric representations of dates and times, especially across countries using different conventions. Zoomdata supports time based on both the 12- and 24-hour timekeeping systems and can read timezone information. In addition, Zoomdata can also interpret UNIX timestamp and time represented in milliseconds. Zoomdata allow you to change the date and time format of time fields in a data source. See Configuring Date and Time Fields.

Zoomdata recognizes the following standard date and time formats for flat file, Amazon S3, Hadoop Distributed File System (HDFS), and Upload API connectors:

  • yyyy-MM-dd HH:mm:ss
  • yyyy-MM-dd HH:mm:ss.SSS
  • yyyy-MM-dd HH:mm:ss,SSS
  • yyyy-MM-dd'T'HH:mm:ss
  • yyyy-MM-dd'T'HH:mm:ssZ
  • yyyy-MM-dd'T'HH:mm:ss.SSS
  • yyyy-MM-dd'T'HH:mm:ss.SSSZ
  • MM/dd/yyyy HH:mm:ss
  • MM/dd/yy h:mm a
  • MM/dd/yy HH:mm:ss
  • MM/dd/yy HH:mm
  • MM/dd/yy hh:mm a
  • MMM dd, yyyy hh:mm a
  • MMM dd yyyy HH:mm:ss
  • dd/MM/yyyy hh:mm:ss a
  • dd/MM/yy hh:mm:ss a
  • yyyy-MM-dd
  • MM/dd/yy
  • MM/dd/yyyy
  • yyyy
  • unix timestamp
  • time as milliseconds

However, there are limitations to be aware of for some of these standards:

  • For fields containing a four digit year (that is, yyyy), Zoomdata recognizes only a limited range of years, specifically, from 1800 through 2020.
  • For fields containing the Unix Timestamp format, Zoomdata is able to read only a limited range of years, specifically, from 1990 through 2020.

Upon successful connection with a data source, Zoomdata displays the results on the Fields page (as shown in Figure 1). Date and time information will be available via either the Timestamp (_ts) column (1) or identified in the Type descriptor (2). Note that if the data source does not provide a Timestamp column, then the admin can edit the Type column to specify a Time attribute.

Was this topic helpful?