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
