INTERVAL column parameters

Interval type belongs to the date/time group of PostgreSQL data types and stores time intervals. This data type is useful for representing difference between two datetime values. You can generate values for this column randomly or choose to take them from an existing table column of the same data type.

The Generation properties panel allows you to define preferences for generating values for Interval column type.

Select Data generation mode as follows:

Generate random data

Set the minimum and the maximum values in the appropriate spin editors. If Min Day value equals Max Day value then use the Hours, Minutes and Seconds to set the upper bound of a time interval (the lower bound defaults to '00:00:00').

Get data from column

This option allows you to specify a column to generate data from: use the Table and Field drop-down lists to select the source table and field that will be used to take data for generation.