[Freeswitch-users] What field type supports microsecond epochs in SQLite CDR?

[Steven Ayre]

Use bigint.

_uepoch values are always an integer not floating point. In sqlite bigint
and double are both (up to) 8 bytes so both have roughly the same range.



On 18 June 2016 at 11:10, vfclists <vfclists at gmail.com> wrote:

>
> What field type in SQLite should be used to store the micro second epoch
> fields like answer_uepoch. Should they be bigint or double?
> --
> Frank Church
>
> =======================
> http://devblog.brahmancreations.com
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20160618/2abd5a49/attachment.html