sysdate comparison issue

[Nikesh, Kishlay]

Title: sysdate comparison issue

Hi,

I am trying to execute the below query through iBatis -

        <select id="getUserDetails" resultClass="valueObject" parameterClass="valueObject">
            SELECT
            column1, column2
            FROM  app_table_name
            WHERE
            (SYSDATE > #property1#)
            AND
            (SYSDATE < #property2#) 
            AND
            TABLE_ID = #property3#
        </select>

It doesn't allow me using < and > in my queries and gives compilation problems.
I tried using isLessThan and isGreaterThan as demonstrated in the tutorial, but wasn't able to do so.

Can anyone please help me on how to define the above query in my iBatis sql mapping xml ?

Thanks in advance,
Nikesh