thanks
On 10/21/2016 3:04 PM, Keith Medcalf wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users