View Single Post
  #1 (permalink)  
Old November 7th, 2006, 03:15 AM
GauravAvi GauravAvi is offline
Registered User
 
Join Date: Nov 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Week Diff in Hibernate

Hello Friends,

I'm using Hibernate/Mysql
I'm applying filter on weeks e.g I could see last weeks' records.
But when there are records of the same month it displays them correct but when there is a month difference (I want to see records of 03/11/2006 to 29/10/2006 then filter is not applying correctly)
not filtering.
The filter applied is given below:

myClassName.start_Date>=current_date-7 and myClassName.start_Date<=current_date

Thanks!
Gaurav


Reply With Quote