sysdate comparison issue

["Nikesh, Kishlay" <ki...@fidelity.co.in>]

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