Time Zone Code generator

Last modified: April 3, 2025

The Time Zone Code generator creates values representing standard time zone abbreviations for testing applications involving global time zones and scheduling.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name Example of generated data Data type matching Country-specific
TZ Code GMT, ACST, CKT, CAT, NUT… character varyingcharactertext Default

Matching rules

The generator can be assigned to a column whose name starts with ‘time’, then goes ‘zone’, preceded or followed by any or no characters, and ends with code, regardless of the table name.

Configure additional settings

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

The Text box displays a .csv file with time zone codes. The default path to the file is C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\TimeZones.csv[0].

Preview of the column data generated by the Time Zone Code generator

Time Zone Code generator