Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - 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
Sender: 3d4f.4d5ab291.1804289383@sybase.com
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: <4d5ab5da.3dc6.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Feb 2011 09:20:26 -0800
X-Trace: forums-1-dub 1297790426 10.22.241.41 (15 Feb 2011 09:20:26 -0800)
X-Original-Trace: 15 Feb 2011 09:20:26 -0800, 10.22.241.41
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
file:

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?

Thanks
Mark Gearhart
Deutsche Bank


Neal Stack [Sybase] Posted on 2011-02-15 18:50:38.0Z
Message-ID: <4D5ACAFE.6090108@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) 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: <4d5ab5da.3dc6.1681692777@sybase.com>
In-Reply-To: <4d5ab5da.3dc6.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 15 Feb 2011 10:50:38 -0800
X-Trace: forums-1-dub 1297795838 10.22.241.152 (15 Feb 2011 10:50:38 -0800)
X-Original-Trace: 15 Feb 2011 10:50:38 -0800, vip152.sybase.com
Lines: 47
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29970
Article PK: 79202

Hello,

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

# 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:
http://en.wikipedia.org/wiki/Time_in_the_United_States#Daylight_saving_time

Sybase CEP's c8_timezone database uses a "date rule" to decide when
daylight savings starts or ends:
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01030.0400/doc/html/asc1252677003893.html

So if we look at these examples:
"America/New_York","EST","Eastern Standard Time","EDT","Eastern Daylight
Time","-05:00:00","+01:00:00","2;0;3","+02:00:00","1;0;11","+02:00:00"
"America/Chicago","CST","Central Standard Time","CDT","Central Daylight
Time","-06:00:00","+01:00:00","2;0;3","+02:00:00","1;0;11","+02:00:00"
"America/Denver","MST","Mountain Standard Time","MDT","Mountain Daylight
Time","-07:00:00","+01:00:00","2;0;3","+02:00:00","1;0;11","+02:00:00"

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?

Thanks,
Neal