SQLite does not have a type of "TIMESTAMP". Only TEXT, INTEGER, REAL, and BLOB. They type of the data in the field depends on what you are storing in it. What are you storing in it (you cannot store Python objects, such as a datetime object, in an SQLite database, only TEXT, INTEGER, REAL or BLOBs).
> ....... > sqlCommand = """ > CREATE TABLE himawari_db ( > date_time TIMESTAMP, > ........ Once you know what you are storing, you will know how to compose a where clause. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users