| FazBrowse GitHub Viewer | Trending | | Home |
| Tools: [Download Repo ZIP] [Original HTTPS Page] |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
@@ -53,6 +53,6 @@ public DateTimeLiteralExpression withType(DateTime type) { | |||
| 53 | 53 | } | |
| 54 | 54 | ||
| 55 | 55 | public enum DateTime { | |
| 56 | - DATE, TIME, TIMESTAMP; | ||
| 56 | + DATE, TIME, TIMESTAMP, TIMESTAMPTZ; | ||
| 57 | 57 | } | |
| 58 | 58 | } | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
@@ -182,7 +182,7 @@ TOKEN: /* SQL Keywords. prefixed with K_ to avoid name clashes */ | |||
| 182 | 182 | | <K_CYCLE:"CYCLE"> | |
| 183 | 183 | | <K_DATABASE:"DATABASE"> | |
| 184 | 184 | | <K_DECLARE: "DECLARE"> | |
| 185 | - | <K_DATETIMELITERAL : ("DATE" | "TIME" | "TIMESTAMP") > | ||
| 185 | + | <K_DATETIMELITERAL : ("DATE" | "TIME" | "TIMESTAMP" | "TIMESTAMPTZ") > | ||
| 186 | 186 | | <K_DATE_LITERAL : ( "YEAR" | "MONTH" | "DAY" | "HOUR" | "MINUTE" | "SECOND" ) > | |
| 187 | 187 | | <K_DBA_RECYCLEBIN: "DBA_RECYCLEBIN"> | |
| 188 | 188 | | <K_DEFAULT : "DEFAULT"> | |
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
@@ -5238,4 +5238,9 @@ public void testNamedWindowDefinitionIssue1581() throws JSQLParserException { | |||
| 5238 | 5238 | public void testNamedWindowDefinitionIssue1581_2() throws JSQLParserException { | |
| 5239 | 5239 | assertSqlCanBeParsedAndDeparsed("SELECT sum(salary) OVER w1, avg(salary) OVER w2 FROM empsalary WINDOW w1 AS (PARTITION BY depname ORDER BY salary DESC), w2 AS (PARTITION BY depname2 ORDER BY salary2)"); | |
| 5240 | 5240 | } | |
| 5241 | + | ||
| 5242 | + @Test | ||
| 5243 | + public void testTimestamptzDateTimeLiteral() throws JSQLParserException { | ||
| 5244 | + assertSqlCanBeParsedAndDeparsed("SELECT * FROM table WHERE x >= TIMESTAMPTZ '2021-07-05 00:00:00+00'"); | ||
| 5245 | + } | ||
| 5241 | 5246 | } | |
| Back | FazBrowse Home | New Git URL |
0 commit comments