On 18 Nov 2015 at 16:52, Andrew Stewart <AStewart at arguscontrols.com> wrote:
> Hi Richard, > I figured out what you did. Not exactly what I am after. College had a > suggestion. I am going to work on adjusting the structure to storing > time/date as BIGINT and do the math on that. I need to be able to adjust the > interval as needed (depending on user request) and not have it fixed to > position in a string. Theres's no DATETIME and no BIGINT. Use INTEGER, see: http://www.sqlite.org/datatype3.html -- Cheers -- Tim
