On 15 Sep 2013 at 18:13, William Drago <wdr...@suffolk.lib.ny.us> 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 been reading the documentation, but it just isn't > clear to me how I should handle this. I convert everything to seconds since the epoch and have a column with that. All comparisons are done against that value. This is not too difficult in PHP. -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users