SQL Query: How to determine "Seen during N hour" if given two DateTime time stamps?
- by efess
Hello all.
I'm writing a statistics application based off a SQLite database. There is a table which records when users Login and Logout (SessionStart, SessionEnd DateTimes).
What i'm looking for is a query that can show what hours user have been logged in, in sort of a line graph way- so between the hours of 12:00 and 1:00AM there were 60 users…
