"Muzaffer Dogru" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
>
> "Denver Braughler" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> news:[EMAIL PROTECTED]
> > Muzaffer Dogru wrote:
> > > 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") [...]
> >
> > [...] WHERE A.DateRangeStart >= Offer_DateConverter("2005-03-04") [...]
>
> Thank you, that works I think...
> Theoretically, for %Time, it should be the same, isn't it?
>
>
Sorry, posted before I had finished...
ClassMethod TimeConverter(time As %String) As %Time [ SqlProc ]
{
quit $ZTIMEH(time, 2)
}
and
[...] WHERE A.TimeRangeStart BETWEEN Offer_TimeConverter("17:00:00") AND
Offer_TimeConverter("20:00:00") [...]
should make the same check for Time, or is it different with %Time? My tests
failed so far.
