It looks like the startTime and endTime are actually stored as text in the sessions table because sqlite has no timestamp type. This makes it difficult to do operations like compute a timedifference. It might be better to store them as integers representing unix epoch time.
It looks like the startTime and endTime are actually stored as text in the sessions table because sqlite has no timestamp type. This makes it difficult to do operations like compute a timedifference. It might be better to store them as integers representing unix epoch time.