diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-08-14 10:12:13 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-08-14 10:12:13 +0000 |
| commit | cdffd0b29d5b072639bb02118d6828f4d1b76099 (patch) | |
| tree | 57ec0b75c40e40a33060b63599bbba6f0af27ae8 /sqlglot/dialects/redshift.py | |
| parent | Adding upstream version 17.11.0. (diff) | |
| download | sqlglot-6e68791db7a256a08b86e35acf69c5ccff399671.tar.xz sqlglot-6e68791db7a256a08b86e35acf69c5ccff399671.zip | |
Adding upstream version 17.12.0.upstream/17.12.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sqlglot/dialects/redshift.py')
| -rw-r--r-- | sqlglot/dialects/redshift.py | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/sqlglot/dialects/redshift.py b/sqlglot/dialects/redshift.py index cdb8d0d..30731e1 100644 --- a/sqlglot/dialects/redshift.py +++ b/sqlglot/dialects/redshift.py @@ -85,8 +85,6 @@ class Redshift(Postgres): "HLLSKETCH": TokenType.HLLSKETCH, "SUPER": TokenType.SUPER, "SYSDATE": TokenType.CURRENT_TIMESTAMP, - "TIME": TokenType.TIMESTAMP, - "TIMETZ": TokenType.TIMESTAMPTZ, "TOP": TokenType.TOP, "UNLOAD": TokenType.COMMAND, "VARBYTE": TokenType.VARBINARY, @@ -101,12 +99,15 @@ class Redshift(Postgres): RENAME_TABLE_WITH_DB = False QUERY_HINTS = False VALUES_AS_TABLE = False + TZ_TO_WITH_TIME_ZONE = True TYPE_MAPPING = { **Postgres.Generator.TYPE_MAPPING, exp.DataType.Type.BINARY: "VARBYTE", - exp.DataType.Type.VARBINARY: "VARBYTE", exp.DataType.Type.INT: "INTEGER", + exp.DataType.Type.TIMETZ: "TIME", + exp.DataType.Type.TIMESTAMPTZ: "TIMESTAMP", + exp.DataType.Type.VARBINARY: "VARBYTE", } PROPERTIES_LOCATION = { |