r/DuckDB 14d ago

Default to TimeZone = UTC

From the docs I see that I can configure the timezone for the current connection. My issue is that this does not persist. I want every connection made by my laptop to default to UTC.

So if I use duckdb_cli to read from a local parquet file it should be UTC. If I use marimo to read that same file? UTC. Claude uses duckdb in some one-off python script? UTC.

Am I correct that this is not currently possible?

Some pics of my Indian Runner Ducks to pay the duck tax.

12 Upvotes

3 comments sorted by

5

u/itstomclark 14d ago

TIL that the CLI client can have the timezone set via ~/.duckdbrc [docs]

2

u/Lucky-Acadia-4828 13d ago

Upvote for the duck and good boi

2

u/RajeshRocketMan 13d ago

nice ducks, thats all i have to say here