Hi, i have a table which holds dates like '2011-12-31 09:00' and i now want to write a query which gives me 2 columns.
First column holds the givin datetime from my table and the second column should show the datetime from first row but 12 hours before. for example: '2011-12-31 09:00' '2011-12-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 the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users