> > SQLite does not have a separate "date/time" datatype. It uses either strings > (preferably in ISO8601 format) or numbers (seconds since 1970 or Julian day > number). > > Your WHERE clause is comparing strings, not dates. If you using ISO8601 > dates in your database file, as you do in the query, it will probably work, > though. >
Ah ok i dont know this. So I must know the exact datetime string format with where pushed in to make a valid string compare when I do selects, right? So SQLITE stores my timestamp I the way it was pushed in. I toughed It has a fixed format to store it. Thank you. Steffen
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users