Dear Teoman,
thank you for the hint. I have tried some different solutions, but none has
worked. Even my hardcoded code
[...] WHERE (TO_DATE(A.DateRangeStart, 'YYYY-MM-DD')) >= "2005-03-04" [...]
returns all entries in the database, even though there is only ONE entry
that fits on this query.
What is the type TO_DATE returns? can I compare it with a String as I did?
Or does it return a %Date and I have to convert "2005-03-04" to a %Date
first?
I have tried to convert it to %Date first, too, with an SQL-PROC as the
following:
[...] WHERE (TO_DATE(A.DateRangeStart, 'YYYY-MM-DD')) >=
Offer_DateConverter("2005-03-04") [...]
with the method:
ClassMethod DateConverter(date As %String) As %Date [ SqlProc ]
{
quit $ZDATEH(date, 5)
}
--> no success...
"Teoman Haliloglu" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> Sorry, wrong paste :))) Corrected below...
>
> > Hi Muzaffer,
> >
> > I had same kind of problems with dates today actually, and I 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?
> > >
> > >
> >
> >
>
>
