EMS logo

Products Navigation

Data Generator for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Generator for MySQL

On-line Documentation

DATE field parameters


Date fields are used for temporal values storage. Values for this field can be generated randomly, incrementally, or they can be taken from a fixed list of values or SQL query, or from an existing table field of the same data type.

 

The Generation properties panel allows you to define preferences for generating date values for date field types.

 

Date field parameters

 

 

Select Data generation mode as follows:

 

RadioButton Generate random data

Set the date range by defining the minimum and the maximum values. Check the Include Time option to generate non-zero random time in addition to the date.

 

Date field parameters - Mode - Random data

 

 

RadioButton Generate incremental data

Specify the Initial Value and the Increment properties to generate an ordered incremented sequence of dates. The incremented value is day.

 

Date field parameters - Mode - Incremental data

 

 

RadioButton Get data from list / SQL query

This panel allows you to define the list of values to generate temporal data from. You can enter these values directly into the editor by selecting the List of Values option.

To add a single value, use the btnListAddValue Add Value button.

To load a list of values from an existing external file, use the btnListLoadFromFile Load from file button.

To save the list to an external file, use the btnListSaveToFile Save to file button.

To remove a single value, use the btnListDeleteValue Delete Value button.

To remove all items from the list, use the btnListClear Clear button.

 

You can also specify whether the values are to be taken in random order or in the order they have been inputted.

 

Alternatively, you can set the SQL Query option and input an SQL query into the editor, and the resulting dataset will be used as the list for data generation.

 

Date field parameters - Mode - List or query

 

 

RadioButton Get data from Field

This option allows you to specify a field 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.

 

Date field parameters - Mode - Field