[Freeswitch-users] Timestamp and timezone issues in CDR, bug or by design?

[vfclists]

When I check the relationship between the epochs and the timestamps, eg
answer_epoch vs answer_stamp I realize that after the daylight saving
change the epochs are an hour behind. Is this by design? Are the timestamps
supposed to be based on the computer's timezone by design, with the epochs
based on the UTC value regardless of timezone and daylight savings?

select
(julianday('2016-03-30 15:23:00')-2440587.5) * 86400.0, --
1459351379.999998, answer_epoch is 1459347780
 (julianday('2016-03-30 14:23:00')-2440587.5) * 86400.0, --
1459347780.000012, value above - 1hr
(julianday('2016-01-27 11:58:53')-2440587.5) * 86400 --1453895933.000001 -
prior to daylight savings

The first 2 are from the sqlite CDR and the last from the CSV file.



-- 
Frank Church

=======================
http://devblog.brahmancreations.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20160620/3200b17c/attachment.html