On 23 Jan 2012, at 3:09pm, Steffen Mangold wrote: > So SQLITE stores my timestamp I the way it was pushed in. I toughed It has a > fixed format to store it.
No, it's completely ignoring timestamp and considers all those as strings. So pick either '.' or '-' and keep to it. > Simple want all events between begin and end of a day. Check the first part of the string to see it matches. You can use substr(X,1,10) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
