Re: [sqlite] Question about date & time

Thanks for the reply. I understand. I am going to do some experimenting just to make sure... Regards, -Bill On 9/15/2013 3:13 PM, Petite Abeille wrote: On Sep 15, 2013, at 8:31 PM, William Drago wrote: Thanks for the reply. Seconds since the epoch does make a good

Re: [sqlite] Question about date & time

On Sep 15, 2013, at 8:31 PM, William Drago wrote: > Thanks for the reply. Seconds since the epoch does make a good timestamp. Is > that what is normally used to extract data between time periods? (Date & Time seems to be a popular topic at the moment) There is

Re: [sqlite] Question about date & time

Hi Tim, Thanks for the reply. Seconds since the epoch does make a good timestamp. Is that what is normally used to extract data between time periods? Say for example, I want to know for the past month what my failure rate was between 11PM and 1AM every day. I'd figure out what 11PM and 1AM

Re: [sqlite] Question about date & time

On 15 Sep 2013 at 18:13, William Drago wrote: > All, > > Should I put date and time in separate columns if I want to > select by time? > > For example: > > SELECT * FROM testresults WHERE (status != "Pass") AND > (23:00 <= testtime) AND (testtime <= 01:00). > > I have

[sqlite] Question about date & time

All, Should I put date and time in separate columns if I want to select by time? For example: SELECT * FROM testresults WHERE (status != "Pass") AND (23:00 <= testtime) AND (testtime <= 01:00). I have been reading the documentation, but it just isn't clear to me how I should handle this.