Sybase CEP stores information about each time zone, including the abbreviation for the time zone, the start date of Daylight Savings Time and the end date of Daylight Savings Time, in a table of Comma-Separated Values.
We loosely refer to this table, and the file that contains it, as the Sybase CEP time zone database. The file is named c8_timezones.csv and a copy is stored in both the server plugins directory and the studio plugins directory.
There are eleven fields in the Sybase CEP Sybase CEP time zone database. The fields are separated by commas. The first line of the time zone database must be a title line containing the column names. This line must be present and contain eleven fields. This title line serves as a memory jog for the fields in the time zone database.
Each line is expected to have eleven fields. Some of these fields can be empty. While fields in the default file are quoted with double quotes, this is not mandatory. An empty field is designated by two successive commas, or by using double quotes, as shown in the 2 examples below:
,, ,"",
Empty lines are ignored. Lines beginning with '#' are comments and are also ignored. Users are encouraged to supply comment and spacer lines.
Some of the 11 fields are lengths of time. Some are date rules that they indicate when daylight savings time starts. Before we describe each of the 11 fields in each row of the database, we will describe the format for lengths of time, and the format for date rules.