Zoomdata Version

Configuring Date and Time Fields

Zoomdata defines a field in your data as a date and time field in the following cases:

  • The field type is timestamp.
  • The field type is numeric containing the number of seconds since the UNIX epoch (UNIX Epoch time). This field type also known as the UNIX timestamp in seconds.
  • The field type is numeric containing the number of milliseconds since the UNIX epoch (UNIX Epoch time). This field type is also known as the UNIX timestamp in milliseconds.
  • The field is numeric and contains a year value.
  • For flat file, Amazon S3, Hadoop Distributed File System (HDFS), and Upload API connectors, the field is a string that matches one of the patterns in Supported Date and Time Formats.

If your data contains a time field, Zoomdata attempts to use the default time format (pattern) established in the data source configuration for the field. If Zoomdata fails to detect a numeric field containing seconds, milliseconds, or years as a time field, change the field in the data source configuration as follows (see Changing the Default Date and Time Format):

If the field contains Change the field in the data source configuration as follows:
seconds Set the field type to Time and specify a custom time pattern of sssssssss.
milliseconds Set the field type to Time. (The default time pattern will be used).
years Set the field type to Time and specify a custom time pattern of yyyy.

If your data contains time-related fields (attributes) that are not stored in a recognized time format, you can convert the fields to time fields using one of the following methods.

You can also manage the time range used when displaying charts and dashboards. See Using the Time Bar.

Zoomdata works with time data in UTC. Zoomdata recommends that you set the timezone for your data source configurations in UTC to avoid time conversion issues.

See also Using the Network Time Protocol to Synchronize Time.

Was this topic helpful?