import sqlite3
import datetime

con = sqlite3.connect(":memory:", detect_types=(
        sqlite3.PARSE_DECLTYPES|sqlite3.PARSE_COLNAMES))
cur = con.cursor()
cur.execute("create table test(d date, ts timestamp)")

today = datetime.date.today()
now = datetime.datetime.now()

cur.execute("insert into test(d, ts) values (?, ?)", (today, now))
d, ts = cur.execute("select d, ts from test").fetchone()
print(type(d))
print(type(ts))

d, ts = cur.execute("select max(d), min(ts) from test").fetchone()
print(type(d))
print(type(ts))

con.close()

# ==== Result: ===
# <class 'datetime.date'>
# <class 'datetime.datetime'>
# <class 'str'>
# <class 'str'>