Datetime generator
The datetime generator creates datetime values with fractional seconds. Under Fill settings, you can set up basic and custom settings.
Custom settings
The settings depend on the selected range type.
Range: Min … Max
Date: Specify the minimum and maximum datetime values. By default, the minimum value is 1/1/1970 and the maximum value is the current date.
Time: Specify the minimum and maximum time values. By default, the minimum value is 00:00:01 and the maximum value is 23:59:59.
Fraction: Select the minimum and maximum seconds values. By default, the minimum value is 0 and the maximum value is 999.
Random: Select this option to generate random values.
Range: Offset from column
Column: Select a column as a time reference point.
Use offset details: Select the option to configure offset details.
- Days: Specify the minimum and maximum days to be added to the reference point. By default, the minimum value is 0 and the maximum value is 7.
- Time: Specify the minimum and maximum timestamps to be added to the reference point. By default, the minimum value is 00:00:01 and the maximum value is 23:59:59.
Range: Offset from now
Use offset details: Select the option to configure offset details.
- Days: Specify the minimum and maximum days to be added to the reference point. By default, the minimum value is 0 and the maximum value is 7.
- Time: Specify the minimum and maximum timestamps to be added to the reference point. By default, the minimum value is 00:00:01 and the maximum value is 23:59:59.
Generator properties
The table provides key details about the generator, including its short name, examples of generated data, supported data types, and country-specific data.
| Short name | Example of generated data | Data type matching | Country-specific data |
|---|---|---|---|
| datetime | 08/07/2026 08:30:45.123, 08/07/2026 11:07:16.250 … | datetime | Default (United States) |
Matching rules
The generator can be assigned to a column that can have any name, regardless of the table name.
Preview of the column data generated by the datetime generator
