Re: [sqlite] Minimum Delta Time

2018-07-11 Thread Stephen Chrzanowski
atetime(StartTime, '+10 minutes') > > ) > > where > > EventID = ? > > and (EndTime is null or EndTime = ''); > > > > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > &

Re: [sqlite] Minimum Delta Time

2018-07-11 Thread Paul Sanderson
e-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Stephen Chrzanowski > Sent: Wednesday, July 11, 2018 10:25 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Minimum Delta Time > > I've got an application that I've written t

Re: [sqlite] Minimum Delta Time

2018-07-11 Thread David Raymond
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski Sent: Wednesday, July 11, 2018 10:25 AM To: General Discussion of SQLite Database Subject: [sqlite] Minimum Delta Time I've got an application that I've written that keeps track of time spent on particular tasks.

Re: [sqlite] Minimum Delta Time

2018-07-11 Thread Simon Slavin
On 11 Jul 2018, at 3:25pm, Stephen Chrzanowski wrote: > interest is modifying the Stop part so that at a minimum, there is a 10 > minute delta between the start and end time. So if I start a timer at > 11:00, then stop at 11:01, I want the database to update the end time to > 11:10. To round a

[sqlite] Minimum Delta Time

2018-07-11 Thread Stephen Chrzanowski
I've got an application that I've written that keeps track of time spent on particular tasks. I do many things throughout the day, going between different tasks, and tasks I've already worked on for today, so this tool is incredibly helpful to help justify my warming a chair. I'd prefer the SQL c