Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Complex Event Processing (CEP) c8_timezones.csv

2 posts in General Discussion Last posting was on 2011-02-15 18:50:38.0Z
Mark Gearhart Posted on 2011-02-15 17:20:26.0Z
From: Mark Gearhart
Newsgroups: sybase.public.ase.general
Subject: Complex Event Processing (CEP) c8_timezones.csv
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <>
Date: 15 Feb 2011 09:20:26 -0800
X-Trace: forums-1-dub 1297790426 (15 Feb 2011 09:20:26 -0800)
X-Original-Trace: 15 Feb 2011 09:20:26 -0800,
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29969
Article PK: 79198

Hi All

Some questions regarding the CEP c8_timezones.csv time zone

Am I missing something? It does not contain the year for
which the offset applies, e.g. before 2007 and after 2007
DST adjustments.

Also, I would like to take the Olson database (also known as
the tz database) and convert it to the c8_timezone.csv
format. Has anyone developed something that would do this?

Mark Gearhart
Deutsche Bank

Neal Stack [Sybase] Posted on 2011-02-15 18:50:38.0Z
Message-ID: <>
From: "Neal Stack [Sybase]" <>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Complex Event Processing (CEP) c8_timezones.csv
References: <>
In-Reply-To: <>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Date: 15 Feb 2011 10:50:38 -0800
X-Trace: forums-1-dub 1297795838 (15 Feb 2011 10:50:38 -0800)
X-Original-Trace: 15 Feb 2011 10:50:38 -0800,
Lines: 47
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29970
Article PK: 79202


I'm not sure I understand your question/concern. In the comments of the

# Various American timezones
# This has been updated for Daylight Savings for 2007. This timezone
change will also apply to ALL previous years!
# For 2007, the date of Daylight Savings time is March 11, 2007 and the
end is November 4, 2007.

So are you going to be analyzing some historical data in CEP?

I'm not sure that I see anything in the Olson database with regards to
start & end dates for pre-2007 versus 2007 to present:

Sybase CEP's c8_timezone database uses a "date rule" to decide when
daylight savings starts or ends:

So if we look at these examples:
"America/New_York","EST","Eastern Standard Time","EDT","Eastern Daylight
"America/Chicago","CST","Central Standard Time","CDT","Central Daylight
"America/Denver","MST","Mountain Standard Time","MDT","Mountain Daylight

So "2;0;3" means:
2 = The second weekday of the month
0 = Sunday
3 = March
Translates to: The second Sunday in March.

And "1;0;11" means:
1 = The first weekday of the month.
0 = Sunday
11 = November
Translates to: The first Sunday in November.

With regards to the Olson database, I have not heard of any customers
converting it into the c8_timezones format. Do you need to do this
because there are missing timezones in the c8_timezones.csv file?