Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug(oracle): incorrect data type mapping for Type.TIMESTAMPTZ #2879

Closed
gforsyth opened this issue Jan 23, 2024 · 0 comments
Closed

bug(oracle): incorrect data type mapping for Type.TIMESTAMPTZ #2879

gforsyth opened this issue Jan 23, 2024 · 0 comments
Assignees

Comments

@gforsyth
Copy link
Contributor

Before you file an issue

[ins] In [4]: sg.__version__
Out[4]: '18.7.1.dev519'

Fully reproducible code snippet
Please include a fully reproducible code snippet or the input sql, dialect, and expected output.

The following should round-trip in Oracle. TIMESTAMPTZ is not a valid type in Oracle.

[ins] In [1]: import sqlglot as sg

[ins] In [2]: expr = sg.parse_one("TIMESTAMP (3) WITH TIME ZONE", read="oracle")

[ins] In [3]: expr.sql(dialect="oracle")
Out[3]: 'TIMESTAMPTZ(3)

Official Documentation
Please include links to official SQL documentation related to your issue.
https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/Data-Types.html#GUID-7B72E154-677A-4342-A1EA-C74C1EA928E6

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants