from datetime import datetime, timezone
import duckdb

dt = datetime.now(timezone.utc).replace(microsecond=0)
print(dt)

q = "CREATE TABLE IF NOT EXISTS test (uid INT, dt TIMESTAMPTZ)"
duckdb.execute(q).commit()

q1 = "INSERT INTO test VALUES (?, ?)"
duckdb.execute(q1, (1, dt))     # BUG time zone
duckdb.execute(q1, (2, str(dt)))
duckdb.commit()

duckdb.sql("SELECT * FROM test").show()

2023-02-25 21:02:54+00:00
┌───────┬──────────────────────────┐
│  uid  │            dt            │
│ int32 │ timestamp with time zone │
├───────┼──────────────────────────┤
│     1 │ 2023-02-25 21:02:54+05   │
│     2 │ 2023-02-26 02:02:54+05   │
└───────┴──────────────────────────┘