<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>This generally depends on the provider. However if you are using a database such as postgresql, you can store time date stamps with a timezone and have your sql extract the tz you want to display. <br><br>Sent from my iPhone</div><div><br>On Jun 20, 2016, at 6:12 AM, vfclists <<a href="mailto:vfclists@gmail.com">vfclists@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr"><div>It is what I was thinking. I just wanted to be sure.<br><br></div>Do service providers generally present the CDRs using UTC time or do they adjust them to the customers time zone?<br><div><div><div class="gmail_extra"><br><div class="gmail_quote">On 20 June 2016 at 03:38, Nathan Neulinger <span dir="ltr"><<a href="mailto:nneul@mst.edu" target="_blank">nneul@mst.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">epoch type timestamps are always UTC by definition, it's a universal/exact format.<br>
<br>
-- Nathan<br>
<div><div class="gmail_signature" data-smartmail="gmail_signature"><br>
On 06/19/2016 08:41 PM, vfclists wrote:<br>
><br>
> When I check the relationship between the epochs and the timestamps, eg answer_epoch vs answer_stamp I realize that<br>
> after the daylight saving change the epochs are an hour behind. Is this by design? Are the timestamps supposed to be<br>
> based on the computer's timezone by design, with the epochs based on the UTC value regardless of timezone and daylight<br>
> savings?<br>
><br>
> select<br>
> (julianday('2016-03-30 15:23:00')-2440587.5) * 86400.0, -- 1459351379.999998, answer_epoch is 1459347780<br>
> (julianday('2016-03-30 14:23:00')-2440587.5) * 86400.0, -- 1459347780.000012, value above - 1hr<br>
> (julianday('2016-01-27 11:58:53')-2440587.5) * 86400 --1453895933.000001 - prior to daylight savings<br>
><br>
> The first 2 are from the sqlite CDR and the last from the CSV file.<br>
><br>
><br>
><br>
> --<br>
> Frank Church<br><a href="http://devblog.brahmancreations.com" target="_blank">http://devblog.brahmancreations.com</a></div></div></blockquote></div>
</div></div></div></div>
</div></blockquote><blockquote type="cite"><div><span>_________________________________________________________________________</span><br><span>Professional FreeSWITCH Consulting Services: </span><br><span><a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a></span><br><span><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a></span><br><span></span><br><span>Official FreeSWITCH Sites</span><br><span><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></span><br><span><a href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a></span><br><span><a href="http://www.cluecon.com">http://www.cluecon.com</a></span><br><span></span><br><span>FreeSWITCH-users mailing list</span><br><span><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a></span><br><span><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a></span><br><span>UNSUBSCRIBE:http://<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">lists.freeswitch.org/mailman/options/freeswitch-users</a></span><br><span><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></span></div></blockquote></body></html>