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

Reply via email to