[sqlite] help with a query using between with a select staement

Hi, i have a select stamement which holds two dates, something like: 2011-12-31 09:002011-12-30 21:00 2011-12-31 18:002011-12-31 06:00 ... let me call this t. and a table 'foods' which also holds a 'time' column and i now want to know all entries in foods which

[sqlite] need help with a query using datetime

-30 21:00' '2011-12-31 12:15' '2011-12-30 00:15' ... looks simple but datetime was not sufficient for this in my research. Very thanks for your help. Greetz looki -- View this message in context: http://old.nabble.com/need-help-with-a-query-using-datetime-tp31868064p31868064.html Sent from