- General Information
- Project Properties
- Database Connection
- Program Settings
- Table Rule
- Advanced Rules
- Built-in Tools
- Advanced Rules
- Additional Information
| Option | Default | Description |
|---|---|---|
| Date format | Depends on locale info | Date value format |
| Date/Time separator | Space | Symbol that will be inserted between date and time for "datetime" values |
| Time format | Depends on locale info | Time value format |
| Years range | 1950 to 2020 | Range of the acceptable years for random dates. This range will be applied to new rules only. |
| Conversion function for Date/Time | Database system specific function that should be applied to convert string to date value | |
| Conversion function for Timestamps | Database system specific function that should be applied to convert string to time stamp value |
Date Format
The format string for date can contain following items:
DD - day, integer between 01 and 31
MM - month, integer between 01 and 12
MON - month, string between 'JAN' and 'DEC'
mon - month, string between 'jan' and 'dec'
YY - two-digits year, integer between 00 and 99.
YYYY - four-digits year, integer.
C - century, integer 0 to 8 value: 0 means 19xx, 1 means 20xx, etc. It is not compatible with YYYY.
Default date format depends on user's culture settings.
Time Format
The format string for time can contain following items:
HH - hour, integer between 00 and 23 (or 01 to 12).
MM - minute, integer between 00 and 59.
SS - second, integer between 00 and 59.
sss - milliseconds, integer between 000 and 999.
AM - AM or PM sign.
zz - time zone between -11:00 and +11:00.
