Querying Date Month

28 views
Skip to first unread message

Leonardo Zanutto

unread,
Feb 6, 2018, 11:17:14 AM2/6/18
to Jinq
Could be a really dumb question but how can I make a expression like want filter column dateEntered where month = 10
like in MSSQL would be : SELECT dateEntered from accounts where Month(dateEntered) = 10

Jinq

unread,
Feb 6, 2018, 11:20:54 AM2/6/18
to Jinq
Jinq relies on JPA/JPQL for its queries, but I don't think that JPA has a way to get the month of a date, so Jinq is not capable of it.
Reply all
Reply to author
Forward
0 new messages