<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(0, 0, 0); font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;">Hello,</span><br>
</div>
<div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
A group of developers including myself has been charged with dealing with time zones in our database. We have been looking into using the IANA TZ Database as our source. In order to create utilities to get historical data correctly, and to future proof our
code as much as possible, there were a couple of questions we have been trying to find the answers to. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="">
<ul style="">
<li style="color:rgb(0,0,0); font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
If an entity breaks off from a current time zone, does the data base fork the current time zone(A) and add a new time zone(B) with time zone B having all the historical data of A?<br>
</li></ul>
<div><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><br>
</font></div>
<ul style="">
<li style="color:rgb(0,0,0); font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)">In the INANA time zone database, the file "europe" contains information for Time Zone Europe/Dublin.</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)">There are three lines that are proceeded with the comment "# These three lines are for when SAVE values are always nonnegative."</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)">These lines are also preceded by comment Delimiter (Please see below).</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)">Since the data follows the Comment Delimiter it is ignored on load. Is database supposed to load this information?</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)">What is the purpose of these comments?</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)"># These three lines are for when SAVE values are always nonnegative.</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)"># 1:00 - IST 1971 Oct 31 2:00u</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)"># 0:00 GB-Eire GMT/IST 1996</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
<span style="font-family:calibri,arial,helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgba(0,0,0,0)"># 0:00 EU GMT/IST</span><br>
</p>
</li></ul>
</div>
</div>
</div>
</body>
</html>