-
-
Notifications
You must be signed in to change notification settings - Fork 1.4k
Description
I am parsing a query with "AT TIME ZONE" operator and getting the error.
query: select systimestamp AT TIME ZONE 'US/Eastern' from dual;
error: net.sf.jsqlparser.JSQLParserException
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:51)
at com.sabre.apd.as.cem.ixintegration.ChandanTest1.main(ChandanTest1.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " <S_IDENTIFIER> "TIME "" at line 1, column 111.
Was expecting one of:
"INTO" ...
"FROM" ...
"WHERE" ...
"FOR" ...
"GROUP" ...
"HAVING" ...
"START" ...
"CONNECT" ...