mardi 6 janvier 2015

How to calculate time difference in SQLite and SUM these values, grouping by day?

I want to calculate total difference between two date fields in SQLite (they are declared as REAL). I.E. datefield1 and datefield2 and group by day.


Datefield1 is login date, datefield2 is logout date. Each day, user can login/logout several times. I want to sum uo logged in time (datefield2-datefield1) for each day.


Aucun commentaire:

Enregistrer un commentaire