Date Query in JPA
How To write Query in JPA base on month selection.

E.g.

There is column effective_date in the table which contains below records 

    1 May 
    1 Jun
    2 July 
    1 Aug

and if current_date is 8 July then it show return 2 July Record


How write such query to retrieve record base on Effective date using JPA  


 


  
Date Query in JPA
===

How To write Query in JPA base on month selection.

E.g.

There is column effective_date in the table which contains below records 

    1 May 
    1 Jun
    2 July 
    1 Aug

and if current_date is 8 July then it show return 2 July Record


How write such query to retrieve record base on Effective date using JPA  


 


  