problem with retrieving records usind date

jaiganesh · **Joined:** Tue Oct 23, 2007 11:06 am **Posts:** 4

when passing Date(YYYY-MM-DD) of this format as one of the arguments,
the date in database is of (YYYY-MM-DD HH:mm:ss), a mapping problem occurs such that i am unable to retrive the records.
C- calender instance,

method(...,..,new java.sql.Date(C.getTime().getTime()))

now how do i retrieve.

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

Post some more information. Code, mapping, column types in db, etc.

As a wild guess may be your columns are timestamp and the value being passed for comparision is not in proper format.

jaiganesh · **Joined:** Tue Oct 23, 2007 11:06 am **Posts:** 4

Calendar c1 = Calendar.getInstance();
c1.set(1998,05,25,00,00,00);

new java.sql.Date(c1.getTime().getTime()) will yield ‘1998-06-25’.

methodName(String, String, new java.sql.Date(c1.getTime().getTime())
||
methodName(String, String, Date). - in implementation class

is there any way that i can use like operator to match the data..a guess?

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

I am still not able to get what you are trying to do and what issue you are facing?

If you can post some details, code, exception (if any)m etc., I might be able to help.