[sqlite] Question about date & time

[William Drago]

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.

Thanks,
-Bill
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users