What field type supports microsecond epochs in SQLite CDR?
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
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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (2)
-
Steven Ayre
-
vfclists