我正在使用 Python 并在 sqlite 中構建了一個表。我沒有意識到 Python 有一個用于 sqlite 的時間戳字段類型，所以我將它存儲為文本。下面是我的代碼和結果.. 表中顯示的唯一日期是 for2019-06-18但查詢返回2019-06-19...不知道為什么import sqlite3# Connecting to the database filesqlite_file = 'insta.sqlite'conn = sqlite3.connect(sqlite_file)c = conn.cursor()# Get all rowsc.execute("SELECT * FROM daily_counts")count_row = c.fetchall()for row in count_row:    print(row)# Get Daily Countc.execute('SELECT count FROM daily_counts where current_date = ? and client_id = ? and metric = ?',    ('2019-06-18', 0, 'C'))count_row = c.fetchall()print(count_row)# Get Daily Countc.execute('SELECT count FROM daily_counts where current_date = ? and client_id = ? and metric = ?',    ('2019-06-19', 0, 'C'))count_row = c.fetchall()print(count_row)# Get Daily Countc.execute('SELECT count FROM daily_counts where current_date = ? and client_id = ? and metric = ?',    ('2019-06-20', 0, 'C'))count_row = c.fetchall()print(count_row)結果：（請注意，當條件為 19 時，它返回 18 的結果，而 18 則不返回任何結果..）(0, u'2019-06-18', u'A', 2)(0, u'2019-06-18', u'B', 6)(1, u'2019-06-18', u'C', 180)(1, u'2019-06-18', u'D', 258)(1, u'2019-06-18', u'E', 111)(0, u'2019-06-18', u'C', 180)(1, u'2019-06-18', u'F', 3)[][(180,)][]我假設我應該使用時間戳字段類型而不是文本？但我仍然希望這能奏效