<HTML><HEAD>
<META content="text/html; charset=ISO-8859-1" http-equiv=Content-Type></HEAD>
<BODY dir=ltr bgColor=#ffffff text=#000000>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'; COLOR: #000000">
<DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
size=2 face=Arial>Hi Angel,</FONT></DIV></DIV>
<DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
size=2 face=Arial></FONT> </DIV></DIV>
<DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
size=2 face=Arial>> </FONT>Matching geo data to a timezone is a bit fuzzy. On
the <BR>> other hand, you state that correct calculation is
critical.<BR></DIV></DIV>
<DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
size=2 face=Arial>We’re working with old protocols that don’t include TZ
information in the data that is sent to us, so we have to get thet TZ info
through geo mapping tables.</FONT></DIV></DIV>
<DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
size=2 face=Arial>We’ve been looking at geopostcodes.com.
</FONT></DIV></DIV>
<DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
size=2 face=Arial></FONT> </DIV></DIV>
<DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
size=2 face=Arial>We’d like it to be as correct as possible, but realize it’s
not possible to cover everything. </FONT></DIV></DIV>
<DIV>
<DIV
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'><FONT
size=2 face=Arial>Eg. 2014-10-26T02:05:00 may refer to
2014-10-26T02:05:00.000+02:00 or 2014-10-26T02:05:00.000+01:00</FONT></DIV>
<DIV> </DIV>
<DIV>> Now I'm thinking that perhaps you aren't working on historic <BR>>
records but with future ones, in which case it's very likely that<BR>> tz
will be right (but in that case why not store them in UTC directly?)<BR></DIV>
<DIV>Our data is all about real-time events, but when reports need to be
regenerated for some reason in the future, they will be historic. Hence
the questions about tz versions.</DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Cheers,</FONT></DIV>
<DIV><FONT size=2
face=Arial>Joris</FONT><BR><BR></DIV></DIV></DIV></DIV></BODY></HTML>