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