Skip to content

document the caveats in timezone-aware timestamps support for Oracle python clients #3495

@ivasio

Description

@ivasio

Documentation description

There seems to be a long-standing issue in python/C driver support of timezone-aware timestamps for Oracle. Namely, if the column is defined as TIMESTAMP WITH TIME ZONE, both cx_Oracle and oracledb truncate timezone info in select results. Impact of that should be studied and documented, in particular for to incremental and reflection_level. Ideally, specific warnings should also be printed

Are you a dlt user?

Yes, I run dlt in production.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

Status

Todo

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions