How do I query for MONTH
This is what I have
select o from Order o where func('month', o.date) = :date
But then I get
ORA-00904: "MONTH": invalid identifier
Already tried several things put can't find a solution
Asked
Active
Viewed 148 times
0
200jaky
- 27
- 5
-
Can you show us at least one of these `several things` you tried? – deHaar May 28 '19 at 13:14
-
`where month(o.date)` `where extract(month, o.date)` for example – 200jaky May 28 '19 at 13:23
-
Have a look at [this question](https://stackoverflow.com/questions/3674567/jpa-query-month-year-functions). – deHaar May 28 '19 at 13:26
-
I saw that one but I keep getting `invalid identifier` – 200jaky May 28 '19 at 13:29
-
Since you got an oracle error message: in Oracle you could get the month like this: to_char(date, 'mm'). Maybe you try func('to_char', o.date, 'mm). – Ralf Renz May 28 '19 at 14:10
-
Thanks that worked. – 200jaky May 28 '19 at 14:16