ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ppakk <pp...@yahoo.com>
Subject ibatis sqlMap query question
Date Fri, 01 Feb 2008 17:37:56 GMT
Hi,

I am using ibatis with DB2 and am doing a
query to see if a row of data has been created
in the past 24 hours.  This query is not working.
Does anyone know what the correct syntax is?

thank you
Paul


<![CDATA[	
	
SELECT 	ITEM_UID
FROM NEWS_DATA
WHERE CREATED_DATE > (CURRENT TIMESTAMP - 24 HOUR) 
]]>


CREATED_DATE is a TIMESTAMP column


      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs

Mime
View raw message