Muzaffer Dogru wrote:
> [...] 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.
Do they all have the year 2005?
> What is the type TO_DATE returns?
String.
> can I compare it with a String as I did?
Yes with a string, not really with ">=".
> Or does it return a %Date and I have to convert "2005-03-04" to a %Date
> first?
Yes.
> 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") [...]
