Hi,

I have a timestamp field in DB. I want to fetch those rows in DB whose timestamp falls between 2 dates.
I have tried this
select fe from ForwardEntry fe
where fe.myTxTs>=:startDate
and fe.myTxTs<=:endDate

If the time stamp falls on 12/12/2005 05:00 am I want that to be displayed when I specify my start and end date as 12/12/2005. This is not working cos the time field is not matching. How can I format the timestamp field in the query so that the date part alone is considered?

Thanks in advance,
Dhanya

why should people help you? you don't give credit.

http://forums.hibernate.org/viewtopic.php?t=948030&highlight=&sid=51ae791635573e8f09a68f8aca93e842

I am sorry. I missed out on the "credit" policy being followed. Let me see what I can do to rectify. :-)

Hi there how to give credit to some one..

just log in to the forum, go to your topic, and click yes next to "Please rate this answer to give credits to the poster! Did it solve the problem?"

Got it thanks dennisbyrne

when i suggest some solution will the initiator of that topic be able to see the same link?

yes, they can see every post to topic.

Hi

I am sorry I didnt rate your earlier response. I wasnt watching the topic and I got the solution I was looking for from another forum.
Anyway I have rated your response that I dont rate. :-)

I havent solved my problem yet, so if someone out there does know the answer please respond.

Thanks,
Dhanya

As far as I know, you can't exactly do this. After all, even with java.sql.Date, the time portion is simply zeroed out. Instead, you would probably be better off rewriting your query slightly as:


and then setting startDate to the target date, and end date to the target date + 1 day (make sure that the time is zeroed out (midnight) for both dates). The change from <= to < in the query will ensure you don't get any timestamps after the specified end date.

Thanks for your response but this worked:

where date(fe.myTxTs)>=:startDate
and date(fe.myTxTs)<=:endDate