Hi Team,
I’m working on my development using open spa dependency and have a
question, I’m trying to extract the YEAR from the DATE datatype Column.
For example: My column name is StatementDate then I’m trying
Select s from statementTable where extract(year from statementDate) = 2020;
But I’m getting an error as openjpa-2.2.3-snapshot;
org.apache.openjpa.persistence.Argumentexception:
"Encountered " Extract ( " at character 87, but expected
: ["(", ")", "*", "+", "-", ".", "/", ":", "<", "<=", "<>", "=", ">", ">=",
"?", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH",
"BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME",
"CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY", "ESCAPE",
"EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INNER", "IS", "JOIN",
"LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", "LOWER", "MAX", "MEMBER",
"MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF", "OR", "ORDER", "OUTER",
"SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "TRAILING",
"TRIM", "TYPE", "UPDATE", "UPPER", "WHERE", <DATE_LITERAL>,
<DECIMAL_LITERAL>, <IDENTIFIER>, <INTEGER_LITERAL>, <STRING_LITERAL2>,
<STRING_LITERAL>, <TIMESTAMP_LITERAL>, <TIME_LITERAL>].
I have also tried other queries with Year(statementDate) condition.
PS: I would like to get the year from the date(mm/dd/yyyy) format which is
of Date data-type.
Thanks
Priyanka
