如何在将日期转换为时间戳并将其存储在SQLite中后搜索特定日期

import datetime

date_string = "2022-01-01"
date_object = datetime.datetime.strptime(date_string, "%Y-%m-%d")
timestamp = date_object.timestamp()

var dateString = "2022-01-01";
var dateObject = new Date(dateString);
var timestamp = dateObject.getTime();

import sqlite3

# 连接到SQLite数据库
conn = sqlite3.connect('database.db')

# 创建表格
conn.execute('''CREATE TABLE IF NOT EXISTS timestamps
             (id INTEGER PRIMARY KEY AUTOINCREMENT,
             timestamp REAL)''')

# 插入时间戳
conn.execute("INSERT INTO timestamps (timestamp) VALUES (?)", (timestamp,))

# 提交更改
conn.commit()

# 关闭数据库连接
conn.close()

const sqlite3 = require('sqlite3').verbose();

// 连接到SQLite数据库
let db = new sqlite3.Database('database.db');

// 创建表格
db.run(`CREATE TABLE IF NOT EXISTS timestamps (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        timestamp REAL
        )`);

// 插入时间戳
db.run(`INSERT INTO timestamps (timestamp) VALUES (?)`, [timestamp]);

// 关闭数据库连接
db.close();

import sqlite3

# 连接到SQLite数据库
conn = sqlite3.connect('database.db')

# 执行SQL查询语句
cursor = conn.execute("SELECT timestamp FROM timestamps WHERE date(timestamp, 'unixepoch') = '2022-01-01'")

# 获取查询结果
result = cursor.fetchall()

# 打印查询结果
for row in result:
    print(row[0])

# 关闭数据库连接
conn.close()

const sqlite3 = require('sqlite3').verbose();

// 连接到SQLite数据库
let db = new sqlite3.Database('database.db');

// 执行SQL查询语句
db.all(`SELECT timestamp FROM timestamps WHERE date(timestamp, 'unixepoch') = '2022-01-01'`, [], (err, rows) => {
    if (err) {
        throw err;
    }

    // 打印查询结果
    rows.forEach(row => {
        console.log(row.timestamp);
    });

    // 关闭数据库连接
    db.close();
});