epoch type timestamps are always UTC by definition, it's a universal/exact format.

-- Nathan

On 06/19/2016 08:41 PM, vfclists wrote:
>
> 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