Python: Package pytz not included about duckdb HOT 5 CLOSED

Yes that's intended:

		if (type.id() == LogicalTypeId::TIMESTAMP_TZ) {
			// We have to add the timezone info
			auto tz_utc = import_cache.pytz.timezone()("UTC");
			auto timestamp_utc = tz_utc.attr("localize")(py_timestamp);
			auto tz_info = import_cache.pytz.timezone()(client_properties.time_zone);
			return timestamp_utc.attr("astimezone")(tz_info);
		}

We need pytz to be able to convert the value to the right python type

from duckdb.

Sorry, I meant "It's intended not being included in the package?"
Taking in count that duckdb is suppose to be light, this would make sense but I wasn't sure.

from duckdb.

Yes that's intended, we don't include dependencies in the package
You could circumvent this issue by casting the TIMESTAMPTZ column to VARCHAR, or TIMESTAMP if you prefer not to install pytz

from duckdb.

Yes that's intended, we don't include dependencies in the package You could circumvent this issue by casting the TIMESTAMPTZ column to VARCHAR, or TIMESTAMP if you prefer not to install pytz

No problem at all, I can totally install pytz.
For some reason I though that datetime conversion would be standard and was not expecting an error.

As this is expected, I'm closing this.

from duckdb.

@Tishj what's the reason for not specifying dependencies, if I may ask? Users that don't want dependencies to be installed can already use --no-deps in pip or equivalent options elsewhere. Alternatively, you could provide a duckdb[full] installation option for users to opt into dependencies.

from duckdb.