Hi Muzaffer, I had same kind of problems with dates today actually, and I remembered that TO_DATE and remembered that for someone, someone had replied with a solution using TO_DATE and TO_CHAR sql functions.
Those functions did solve most of my problems, maybe they can solve yours too.. Regards, Teoman "Muzaffer Dogru" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > "Denver Braughler" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > news:[EMAIL PROTECTED] > > Muzaffer Dogru wrote: > > > There must be some error with the type... > > Yes, the %Date is not the same type as java.sql.date. > > Somehow you are receiving the wrong type. > > "The logical value of the %Date data type is in Cache' $H format." > > > > Possibly you should be converting to a Cache date on the Java side. > > The binding might work only for properties not arguments. > > on Java side it is fine. How can I convert the Java date or a String on > Cache side to the right format? > >
